how to calculate total in ms sql server reporting services

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

Latest Posts