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.
| 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 |
 |
|
|
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? |
|
|
|
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 |
|
|
|
|
|
|
SSRS Add Totals from multiple Datasets