Group Count

Good Morning.

This should be fairly easy but for the life of me, I can't figure it out...

I am using SQL reporting Services 2000 and Visual Studio 2003.

I have a very simple report that is grouped by a users name. What I can't figure out is how to get the count of records in a group. I have already got the total number of records for all groups but I also need to have the Group count as well.

Any help would be greatly apprceiated

Try the inscope function?

http://devauthority.com/blogs/chrisslatt/archive/2005/07/06/Reporting_Service_Using_InScope_to_do_custom_subtotals.aspx

|||

For table like this:

Table Header:
Group Header:
Detail:
Group Footer:
Table Footer:

I do the following: add COUNT() into Group Footer line. It will calculate you number of rows for each group. If you put COUNT to Table Footer it will calculate you total number of rows. It's for simple situation. In case of complicated calculation and table structure you can use InScope, as Andrew told you.