Need help in building Paginated report, data coming from two tables

[ashmitp869]

Hi All,

I am trying to achieve a simliar paginated report like I build in Power BI. As I need the report to be exported to PDF with multiple pages.

Power BI report looks like below.

In Paginated report I am unable to bring the relationship though I am using the Power BI dataset as the paginated report dataset.

How I Show the PTD Claim in one rows similar like my power BI.

Considering Actuals having multiple dates and cost.

Please find sample rdl file attached 

https://github.com/suvechha/samplepbi/blob/main/sample.rdl

Any help is appreciated. Thanks

[Anonymous]

Hi @ashmitp869 ,

Consider using PBI Desktop to connect these two semantic models through the DirectQuery to AS feature, then create relationships between the appropriate tables, then publish to the PBI service, and finally use the PBI report builder to connect this semantic model.

If you can't create a proper relationship, you can also rewrite the measure to pass the filter for the current row of table1 to the table2, something like this:

Measure = 
// Here I passed [Country] and [Product] from table1 to SUM(‘Table2’[Profit])
VAR __cur_filter1 = SELECTEDVALUE('Table1'[Country]) 
VAR __cur_filter2 = SELECTEDVALUE('Table1'[Product])
VAR __result = CALCULATE(SUM('Table2'[Profit]), 'Table2'[Country]=__cur_filter1 && 'Table2'[Product]=__cur_filter2)
RETURN
__result

It works fine in paginated reports:

Hope this helps.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[ashmitp869]

Hi @Anonymous ,

I have given a sample paginated report. will you be able to help me get the measures.

https://github.com/suvechha/samplepbi/blob/main/sample.rdl

my requirement is to show PTD Claim

Which is coming from Actuals.

The Data model :

Please if you have help.