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
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
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 Function、LookupSet Function、Multilookup 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.
LookupSet is working on the same dataset or it pulls data from a second dataset base on matching condition?
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.
5 people are following this question.