Total Row Count for Grouped Values in SSRS 2008

reporting-services ssrs-2008 dynamics-crm-2011
user2287143 picture user2287143 · May 1, 2013 · Viewed 57.8k times · Source

I have a report that displays names of all accounts and activities performed under each of them.

AccountName: ABC Corp Activity: Installation

I want to group the AccountName and get the total number of Activities performed for each account.

ABC Corp: 1

How can I accomplish this in SSRS 2008? I am able to group the AccountName but I need a way to convert the Activity column to int so I can get the total.

Help appreciated!

Answer

amartine picture amartine · May 1, 2013

You can add a total row for the Account group and give your total field the expression CountRows("AccountGroupName"), to count the Activity detail rows for each Account group.

You can also put the total value at the level of the group row / group header.

More details about Function CountRows could be found here: http://msdn.microsoft.com/en-us/library/ms156330(v=sql.100).aspx

Related questions

How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More
SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More