How to create Paginated reports with links subreports

[nbs333]

Hi, 

I am new to Paginated reports and am trying to understand how to implement a report required by my company. Essentially it is a paginated report that has an overview page that links to other paginated reports. The end goal is to export this to pdf with functional links. ( Example ) 

I have been about to make a simple report but I am not sure how to link all the report in to one master file. I've read about making a document map but would I have to make seporate rdl files, host them on service and link them to a master file? 

Any guidence is greatly appreciated as I have searched everywhere and am not sure the best way forward.  Thanks

[parry2k]

@nbs333 you can create multiple tables in one rdl file and use the common parameters to filter the dataset for each table and that will do it.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[nbs333]

@parry2k I figure out how to put multiple reports in one rdl file by using the pagebrake option for each table.

How can I create a link to each one for these pages so when I export as a PDF the links still work? 

[nbs333]

Hi @parry2k thank you for the responds. I'm not sure I fully understand as this is all new to me.

By "you can create multiple tables in one rdl file,"does that mean I would create a subreport for each linked report/page?

Do you know where I can find a guide that would give an indepth explination?