|
Hi all, I have this query And basically what I need to add is a total balance for all terms for a student prior to the current term. I am doing this in SSRS so I was thinking of creating a parameter of current term start date and calculating the total balance prior to the specified current term start date. So a balance for terms
(comments are locked)
|
|
SSRS summing and grouping is a lot less rigid than TSQL. Cant you return your dataset to the report and then create a report or group footed and place the SUM function in there as needed? I know I tried to do that but the problem is that my dataset also returns data for the current term which I need to see as well so I can not filter it out. If I group it and do a sum it includes the current term in the sum. Any workaround?
Aug 23 '12 at 06:42 PM
muk
cant you group the report data by term and then have a sum for each?
Aug 23 '12 at 07:00 PM
Fatherjack ♦♦
Yes but thats not what I need I need a total sum of all terms that are not the current term. doing that gives me the individual sums for each term I need to add these together - current term to get the total I need
Aug 23 '12 at 07:01 PM
muk
(comments are locked)
|

