Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ATexas
Starting Member
3 Posts |
 Posted - 2010-02-23 : 15:39:45
|
| I want to get the row number for every row in a table like this:1) Group 12) . . . Detail 13) . . . Detail 24) . . . Detail 35) Group 1 TotalI have tried using =RowNumber(Nothing)=RowNumber("Tablix1")but the result is:3) Group 1 (puts the number of details in the group)1) . . . Detail 12) . . . Detail 23) . . . Detail 33) Group 1 Total (puts the number of details in the group)It only puts the row number for the detail lines and this will not give me an accurate count of the number of rows displayed on the report.How can I get an accurate row number for Every Row regardless if the row is a group heading, group total or detail row?Thanks!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-24 : 10:20:35
|
| you mean you want row number to go continuos regardless of levels?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ATexas
Starting Member
3 Posts |
Posted - 2010-02-24 : 10:34:42
|
| Yes, I want the actual row number for each row, regardless of levels. |
|
|
|
|
|
|
Row Number for every row