Auto Row number in SSRS with grouped rows

Question

I am working with SSRS 2008. In one of my reports, I have a table with three columns. Sr. No, column 1, column 2. Sr. No -RowNumber ("DataSet"), and the others are two columns of the data set. I have grouped (Row Group) my table in column 1 and column 2. This is normal, but column Sr.No does not show the correct score, which shows the row number of the grouped row, for example, 2,4,9,10 and so on. I want to keep the Sr.No or row number after grouping and on top of the table. I want to show the number of rows in a table after grouping.

suggest

Answer 1

For different line numbering, you can try the following:

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

If the report has only one level of grouping, you can group your values ​​in an SQL query, and then add a new column, ROW_NUMBER() OVER(...) , already numbering your rows in the SQL query.