topic Re: Paginated report - nested tables with different datasets in Report Server

Paginated report - nested tables with different datasets

Markzolotoy — Tue, 13 Apr 2021 19:11:38 GMT

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

Thanks

Re: Paginated report - nested tables with different datasets

v-janeyg-msft — Fri, 16 Apr 2021 06:35:12 GMT

Hi, Markzolotoy

This tutorial can solve your problem very well: Create a paginated report with a Power BI shared dataset - Power BI Report Builder - Power BI | Microsoft Docs You can refer to it patiently.

According to your description, You need to create the relationship in desktop and create a summarize table,then copy the query to report builder.

Like this:

Reference:SUMMARIZECOLUMNS function (DAX) - DAX | Microsoft Docs

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Paginated report - nested tables with different datasets

AbhiSSRS — Fri, 16 Apr 2021 07:08:36 GMT

Hi!

Unfortunately you can work only with single dataset for a group in a tablix, you may though use lookup to get values from another dataset. If you can provide more details on your datasets and end Visual targeted sketch then maybe could suggest something !

Re: Paginated report - nested tables with different datasets

v-janeyg-msft — Thu, 29 Apr 2021 06:28:49 GMT

Hi, Markzolotoy

Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.