How to show row count in SSRS per grouping on variable group-by value?

reporting-services grouping row-number
D'Arcy Rail-Ip picture D'Arcy Rail-Ip · Apr 22, 2013 · Viewed 55.8k times · Source

Essentially, I'd like to have separate row counts per grouping. I believe I'm supposed to use RowNumber. This seems to have been discussed but I'm having difficulty due to the fact that my groupby is not a string constant.

My attempts have lead to something that is similar to :

=RowNumber(Parameters!GroupBy1.Value)

The SSRS report doesn't load if I have this set as it is.

Row counts per DS work. If instead I use:

=RowNumber("NameOfMyDataSet")

I'll have row counts successfully, but without resetting per group.

How can I reset the row-count per group if I'm using a variable group-by name?

Answer

Ian Preston picture Ian Preston · Apr 22, 2013

You need to set the scope of the function as the name of the group, not the DataSet, something like:

=RowNumber("Group1")

Edit after comment:

As above this is the name of the group created in the report, not any of the values in the DataSet.

In Designer:

enter image description here

Group properties:

enter image description here

Related questions

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
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
SQL variable to hold list of integers

I'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One of the parameters the report asks for is a list of integers. This is achieved on the report …

Read More