I have a group in my report where I have to use row numbers within that group, I was wondering if there is a way to display row numbers using expressions, or if I have to modify my Store procedure and include row numbers for that group.
Row number within an SSRS report
7k Views Asked by Avinash At
2
There are 2 best solutions below
2

You can use the RowNumber function in Reporting Services.
Since SQL Server 2005 this can be done with ROW_NUMBER() in the SQL code too.
Neither way is better for simple groups, but if you have dynamic groupings that you're better with the SSRS RowNumber which will calculate over the group/scope
Yes, row number is the answer. use it like this
Here is how to do Paging in SQL