Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

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 enter image description here

Report design

enter image description here

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     |
---------------------------------------------------------------------

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
3.2k views
Welcome To Ask or Share your Answers For Others

1 Answer

等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...