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

Categories

0 votes
3.6k views
in Technique[技术] by (71.8m points)

reporting services - SSRS report - pivoting data (last columns grouping)

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...