I am trying to achieve the attached prototype for ssrs report. I was able to get all the data but can not figure out how to show the last three columns ("First Time Posted", "Last Time Cancelled" and "Total Duration")
When i try with expression it show data for every single corresponding line, just want to show one entry based on group.
Thank you,
Desired output
Report design
Data will be like
| Cp Label | Time Posted | Time Cancelled| Duration | Link ID|
---------------------------------------------------------------------
| Cp 1 | 12:56:00 | 12:57:05 | 00:01:05 | 1 |
---------------------------------------------------------------------
| Cp 2 | 12:57:05 | 1:00:00 | 00:02:55 | 1 |
---------------------------------------------------------------------
| Cp 3 | 12:57:00 | 1:15:00 | 00:18:00 | 2 |
---------------------------------------------------------------------
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…