Summary Report of Main Report

Question

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?

Answer 1

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)

---

Hope this will help you !!!
Sanjeewan

Answer 2

Thanks for the reply, I will try this in a new table.

Answer 3

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:

If you have any questions, please feel free to ask.

Regards,
Charlie Liao

TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Answer 4

Thanks for the help guys.