How to sum up the total in a column in SSRS 2008

Question

Post reply

How to sum up the total in a column in SSRS 2008

klineandking

SSCrazy

Points: 2570
More actions
January 28, 2010 at 11:44 am

#216096

Good morning guys, i have a question, i have a report that has numeric columns i want the user to see the grand total of the columns at the end of the report, is there a function for it in ssrs 2008 aside from the 'Add Total' property when you right click on a cell.Thanks

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

wschampheleer SSCertifiable Points: 5504 More actions · Answer 1

Add a text box, create an expression it it, use SUM function.

If that's not what you're looking for, please be more specific on your request.

Regards,

Willem
http://wschampheleer.wordpress.com[/url]

klineandking SSCrazy Points: 2570 More actions · Answer 2

Thank you that works, i have one more question;how can you view the stored proc a report is using if the report has so many Procs in its data set

wschampheleer SSCertifiable Points: 5504 More actions · Answer 3

I'm sorry - I don't understand the question.

Regards,

Willem
http://wschampheleer.wordpress.com[/url]

klineandking SSCrazy Points: 2570 More actions · Answer 4

i meant how could i view the stored proc a report is using if the report has so many Procs in its data set in ssrs

wschampheleer SSCertifiable Points: 5504 More actions · Answer 5

I'm still puzzled by your question but I'll give it a shot.

Select a list or tablix in your report and press F4. Look for the propery DataSetName.

Select the DataSet in the Report Data Pane, right click and select DataSet Properties.

Here you will find either the query or the name of the Stored Procedure (SP).

Use SQL Server Management Studio to look at the code of the SP.

If the expression is in a stand alone text box (rather than part of a tablix or list), just look at the expression inside to find out what dataset it is using.

Regards,

Willem
http://wschampheleer.wordpress.com[/url]

klineandking SSCrazy Points: 2570 More actions · Answer 6

klineandking

SSCrazy

Points: 2570

February 1, 2010 at 9:22 am

#1111712

Thank you i appreciate it