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

Popular posts from this blog

monitor web browser programmatically in Android? -

Shrink a YouTube video to responsive width -

wpf - PdfWriter.GetInstance throws System.NullReferenceException -