SSRS Row Group + Column Group = RowNumber Issue

reporting-services row-number
Bennett Dill picture Bennett Dill · Dec 1, 2009 · Viewed 39.6k times · Source

I'm back with another SSRS question :-)

I'm dealing with survey data. I have a procedure that's returning an organization's response counts per question. So my report is defined as Group on Organization for row and Group on answer for columns. Both the number of organizations and answers are variable. That's working as expected. I've tried adding a RowCount next to the organization so that I can show rank, but the fact that each org has one row per question means that I'm getting eight rows per org.

Here's an example:
Chart

Here is my report definition:
Chart
The rank expression is currently: =RowNumber(Nothing)

Ideally, the rank would be 1, 2, 3, 4, etc... I've tried scope to the row group, column group and nothing. No help.

Any assistance would be greatly appreciated!

Answer

Screaminskull picture Screaminskull · Oct 31, 2011

Had same frustrating issue; lots of time wasted. Eventually, this solution also helped:

=RunningValue(CountDistinct("YourTableName"),Count,"YourTableName")

Trick here is NOT to use the name of the group within the table/matrix, but the name of the table itself. And yes, one would think that using the table name for the scope in the function RowNumber should work, but it doesn't.

Related questions

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

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 …

Read More
SSRS Row Number within table excluding hidden rows

I use the following expression to obtain a row number for a table in SSRS: =RunningValue(CountDistinct("Table1"),Count,"Table1") I also use an expression for the row visibility property. Lets just say that the Visibility expression is =IIf(Fields!…

Read More
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