Geek asks and answers

How to show the number of rows in SSRS for each group by the variable group-by value?

Essentially, I would like to have a separate line counter for each group. I suggest that I should use RowNumber. This seems to have been discussed, but I am having difficulty because my group is not a string constant.

My attempts led to something similar to:

=RowNumber(Parameters!GroupBy1.Value)

SSRS report does not load if I have this set as is.

Number of rows per DS job. If instead I use:

=RowNumber("NameOfMyDataSet")

I will have the number of rows successfully, but without a reset for each group.

How can I reset the row count for each group if I use the group-by variable?

+5
source share
1 answer

, DataSet, - :

=RowNumber("Group1")

:

, , , DataSet.

:

enter image description here

:

enter image description here

+17

More articles:


All Articles