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
1
2
3

2 ClaimID2
1
2
3
4
5

3 ClaimID3
1
The following expression helped adding the row number for the groups
=RunningValue(Fields!ClaimID.Value, CountDistinct, Nothing)

Comments:
Thank's, this helped a lot.
 
THANK YOU! I have been working on this for days!!!!
 
Thanks for your sharing.

I am nobody from Taiwan
 
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!
 
thanks man just stumble upon your post when I was looking for numbering for Group, thanks.
 
thanks dude.
keep posting good stuff
 
Thanks a lot for your sharing
 
Thanks heaps man.. Just what I was after!
 
Post a Comment

Subscribe to Post Comments [Atom]





<< Home

This page is powered by Blogger. Isn't yours?

Subscribe to Posts [Atom]