Share via

SSRS report - nested tables with different datasets

Zolotoy 226 Reputation points
2021-04-13T19:08:35.37+00:00

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
0 comments
Accepted answer
  1. Joyzhao-MSFT 15,631 Reputation points
    2021-04-14T02:46:03.22+00:00

    Hi @Zolotoy ,
    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.