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 |
|
russellsql
Starting Member
1 Post |
 Posted - 2010-11-30 : 13:43:47
|
| Using ssrs 2005 BIDS. There are 2 datasets and I want to bring in information for both on the same table. The 1st dataset is grouped by location and it works. I want the data from the 2nd dataset to be in the same table and to be grouped by location. The following expression in the group row returns the grand total not the location totals:=sum(Fields!Total_Current_Balance.Value, "RetailCDs") |
|
|
|
|
|
Multiple datasets in same table