How to Group in SSRS report 2005
-
Tuesday, January 29, 2013 12:24 PM
Hi All;
Below is my table
Based on Duration I need to add my client id in SSRS report 2005 1+1+3 =5
Any help much appreciated
Thanks
Pradnya07
- Edited by Simran08 Tuesday, January 29, 2013 12:25 PM
All Replies
-
Tuesday, January 29, 2013 4:04 PM
Have you tried select distinct? Ex:
select distinct clientname, clientid, duration, totalduration from tablename
You can get the sum by using this expression:
Sum(Fields!clientid.Value)
Or use this example to get distinct values for the clientid column: Custom Aggregates
- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Wednesday, January 30, 2013 2:09 AM
- Marked As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Monday, February 04, 2013 1:16 AM
.png)
