Summary Report of Main Report

# Summary Report of Main Report

• Friday, September 21, 2012 8:28 AM

I am using SSRS 2008. I have developed a report which has a Parent group called Area and a Child group called Status.

Area can be A, B, or C.

Status can be Open, Closed, New.

The report is like this:

Area A

Status New

Count of Apps 'New' in Area 'A' = 10

Status Open

Count of Apps 'Open' in Area 'A' = 18

Status Closed

Count of Apps 'Closed' in Area 'A' = 2

Area B

Status New

Count of Apps 'New' in Area 'B' = 17

Status Open

Count of Apps 'Open' in Area 'B' = 20

Status Closed

Count of Apps 'Closed' in Area 'B' = 6

What I want is to have a separate table at the bottom of the report which gives a count of the number of Status e.g.

Total Number of 'Open' = 38

Total Number of 'Closed' = 8

Total Number of 'New' = 27

I want a summary like the above which can be displayed on another page at the bottom of the report where it shows the combined total of each Status from the main report.

Anyone got any ideas?

### All Replies

• Friday, September 21, 2012 8:51 AM

Hi,

Insert a 3 row under parent group  or use different table and put your expression like this

=Count(Fields!open.Value)

=Count(Fields!Closed.Value)

=Count(Fields!New.Value)

Sanjeewan

• Marked As Answer by Monday, September 24, 2012 3:00 PM
•
• Friday, September 21, 2012 2:46 PM

Thanks for the reply, I will try this in a new table.
• Monday, September 24, 2012 1:57 AM
Moderator

Hi Jmccon,

I have tested it on my test environment, it can be done.  Just add another matrix below to the table, and then add a column groups for the amount, then add a row total for the amount. The steps below are for your reference.

1.Drag a matrix control below to the table.
2.Drag “Area” and “Amount” to the first column and second column.
3.Add a column group for “Amount”, parent group is “Status”.
4.Add a row total for the “Amount”.

The report looks like bleow: