question

EvgheniiLuchianic-8016 avatar image
0 Votes"
EvgheniiLuchianic-8016 asked Joyzhao-MSFT commented

please help with grouping details and totals

I am trying to get the same layout going in ssrs as in the picture below.
Bascially there is a parent group on business area/line and then it groups on event type too and does the totals on the top line. right underneth the totals for the event type it goes into the detail to list each one of those events that make up the total on the line above. How can i achieve this in SSRS?

142231-screenshot.png


sql-server-reporting-services
screenshot.png (40.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @EvgheniiLuchianic-8016 ,
If you want to display the total number of information at the top of the report, and the detailed information row at the bottom half, you could consider using the form of subreports or nested data regions. For more information, please refer to: Subreports in paginated reports (Report Builder), Nested data regions in a paginated report (Report Builder).
Best Regards,
Joy


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

So i am very close to having it working working as it should. But I still have one issue. It is not showing the details for the first event type only for second. Please see below. Any help would be appreciated!

142456-ssrs-issue-1.png


The downtime event type group should have 6 rows underneath with details.

Here is my tablix design

142571-ssrs-tablix.png


0 Votes 0 ·
ssrs-issue-1.png (19.8 KiB)
ssrs-tablix.png (16.0 KiB)
Joyzhao-MSFT avatar image Joyzhao-MSFT EvgheniiLuchianic-8016 ·

From your group information, everything is normal. Could you share some test data so that I can test on my local device?

0 Votes 0 ·