reporting services - Auto Row Number in SSRS Table with Grouped Rows -
i working ssrs 2008. in 1 of report have table 3 columns. sr. no, column 1, column2. sr. no -rownumber("dataset") , other 2 data set columns. have grouped (row group) table on column 1 , column 2. ok sr.no column doesn't show right count shows row number of grouped row e.g 2,4,9,10 on. want keep sr.no or row number after grouping , on top of table want show count of rows in table after grouping.
please suggest
for distinct numbering of rows can try this:
=runningvalue(countdistinct("yourtablename"),count,"yourtablename")
if have 1 grouping level in report, group values in sql query , add new column row_number() over(...)
numbering rows in sql query already.
Comments
Post a Comment