Wednesday, November 29
Group Number in SQL Reporting Services
Found this after lot of searching.
I was grouping data in a table in a SQL report. I could successfully add row numbers to the details of the group but was unable to add row numbers to group header.
Something like this
1 ClaimID1
2 ClaimID2
3 ClaimID3
=RunningValue(Fields!ClaimID.Value, CountDistinct, Nothing)
I was grouping data in a table in a SQL report. I could successfully add row numbers to the details of the group but was unable to add row numbers to group header.
Something like this
1 ClaimID1
1
2
3
2 ClaimID2
1
2
3
4
5
3 ClaimID3
1The following expression helped adding the row number for the groups
=RunningValue(Fields!ClaimID.Value, CountDistinct, Nothing)
Comments:
<< Home
Thank you VERY much! This was driving me crazy as the regular RowNumber() expression doesn't work correctly with groups! Simple and perfect solution. Thanks again!
Post a Comment
Subscribe to Post Comments [Atom]
<< Home
Subscribe to Posts [Atom]