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
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 MULTIPLE DATASETS RESULTS IN MY REPORT

Author  Topic 

Blessed1978
Yak Posting Veteran

97 Posts

Posted - 2014-08-07 : 15:49:57
I have a query in dataaset 1 that is doing exactly what i want to do, now i want to add an additional row in my report based on a seperate select statement which i will add to dataset 2. when i run the report it only shows dataset 1 results but not 2.

How can a make my results show both datsets querries in my report

tm
Posting Yak Master

160 Posts

Posted - 2014-08-08 : 10:04:23
Assuming you are displaying dataset in a table object.

Two options:

1. Add a second Table object and display dataset 2 records
2. Modify dataset 1 to include records from dataset 2 query and display in the table object

Go to Top of Page
   

- Advertisement -