Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SSRS Add Totals from multiple Datasets

Author  Topic 

Vack
Aged Yak Warrior

530 Posts

Posted - 2014-11-17 : 14:48:44
I have 3 tables pointing to 3 different datasets on my report.

How Can I take the totals from Each Table(Dataset) and add them together for a Grand Total?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-11-17 : 15:06:43
Yup. You just need to use and expression that adds the sums from the three datasets. e.g.

=Sum(Fields!data.Value, "dataset1") + Sum(Fields!data.Value, "dataset2") ... etc
Go to Top of Page

Vack
Aged Yak Warrior

530 Posts

Posted - 2014-11-17 : 15:15:27
I get a message Unknown Collection Member

=Sum(Fields!qty_remaining.Value,"POData")

Where do I add the expression? I was trying to put it in my last table.

or do I add a new table to the report?
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-11-17 : 15:26:12
You put the expression in the text box where you want to show the total. You don't need a new table, just a simple textbox
Go to Top of Page
   

- Advertisement -