reporting services - RowNumber for group in SSRS 2005 -
i have table in ssrs report displaying group, not table details. want find out row number items being displayed can use color banding. tried using "rowcount(nothing)", instead row number of detail table. my underlying data rowid team fan 1 yankees john 2 yankees russ 3 red socks mark 4 red socks mary ... 8 orioles elliot ... 29 dodgers jim ... 43 giants harry my table showing groups looks this: rowid team 2 yankees 3 red socks 8 orioles 29 dodgers 43 giants i want like rowid team 1 yankees 2 red socks 3 orioles 4 dodgers 5 giants you can runningvalue expression, like: =runningvalue(fields!team.value, countdistinct, "dataset1") dataset1 being name of underlying dataset. consider data: creating simple report , comparing rownumber , runningvalue approaches shows runningvalue gi