question

Zolotoy-3922 avatar image
0 Votes"
Zolotoy-3922 asked Joyzhao-MSFT edited

SSRS report - nested tables with different datasets

I need to have a table in a cell of another table because second table is details table. The details are coming from a different dataset. Is it possible to make it work?

Thanks

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @Zolotoy-3922 ,
Unfortunately, one data area in SSRS will point to only one Dataset. If you want to get data from two Datasets, you need to create another Dataset that will merge queries from the other two Datasets and aggregate the data into one Dataset.

In addition, in some cases, you could also choose to use expressions to get some data in the second Dataset, such as Lookup FunctionLookupSet FunctionMultilookup Function.

Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LookupSet is working on the same dataset or it pulls data from a second dataset base on matching condition?

0 Votes 0 ·

Returns the set of matching values for the specified name from a dataset that contains name/value pairs. It is what you said is extracting data from the second data set based on matching conditions.
Pay attention to distinguish the application of Lookup function, LookupSet function and Multilookup function. In the above answer, there are links to the usage of these three expressions. You can click to check out.


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 Votes 0 ·