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 :
The SSRS report doesn't load if I have this set as it is.
Row counts per DS work. If instead I use:
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?
You need to set the scope of the function as the name of the group, not the DataSet, something like:
Edit after comment:
As above this is the name of the group created in the report, not any of the values in the DataSet.