CODEWITHSUNDEEP
reporting-services
cluc
cluc

Reputation: 11

SSRS - Report Summary Detail display formatting

I've been fiddling around with SSRS and going through google search for a solution, but haven't had much luck. My SQL queires are running fine, however trying to get it to display in a specific way on SSRS was a challenge.

I basically have a detail query and a summary query based on a grouping and my goal is to display the summary and the grouping per page on SSRS, hopefully the data and format below explains it.

Currently have the following data:

The goal is to be able to produce a report to display as follows:

Page 1:

Page 2:

Page 3:

What I'm actually getting:

Page 1:

Page 2:

Page 3:

Page 4:

Page 5:

The data is correct, however the way it's grouping/displaying is all whacked. - I've tried having 2 queries one to produce the detail and one to produce the summary and also tried joining them into 1 big table, but the results are still not correct.

Has anyone experienced anything similar or has a workaround?

Upvotes: 1

Views: 832

Answers (1)

Trubs
Trubs

Reputation: 3032

There is no need for two result sets. Using the single result set listed above assigned to your tablix, create the group on your GroupingCode. When creating the group, Mark the checkbox to Add group header

enter image description here

or if you already have the group set up, you can simply add a Total before the detail row

enter image description here

ps - screenshots go a long way to understanding the problem

Upvotes: 2

Related Questions