how to calculate total in ms sql server reporting services

Posted by RohiK under Sql Server on 12/6/2011 | Points: 10 | Views : 1371 | Status : [Member] | Replies : 2
Hi

I have expression fields in my report
i want to show the total of all columns below then as grand total.
How to do that?
I am using groups

Happy Programming!!
Rohi



Responses

Posted by: Sksamantaray on: 12/8/2011 [Member] Silver | Points: 25

Up
0
Down
1.create a custom function and pass the value of all your cols, add there , show the return value below the table
or
2.cteate another dataset which holds calculated value of all your columns



Thanks,
Sanjay

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 5/23/2012 [Member] Starter | Points: 25

Up
0
Down
1) ADD NEW PARAMETERS IN REPORT WINDOW
2) IN THAT PARAMETERS SUM(COLUMNNAME)
3) DRAG THE COLUMN IN THAT TABLE

REGARDS

sriram

RohiK, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response