From a list of multiple projects, I want users to be able to export .pdf and .pptx files where each page corresponds to one project and its correspondant information.
For this I've set up a report where the first page looks like this:
Each of the slicers is connected to one hidden page. The slicers all come from the same table-column, Projects-Project Name, so the user selects one project per slicer, therefore populating each hidden page with the data correspondant to its selected project. It works perfectly fine if all slicers (and therefore their pages) have a value ( I havent tried this with the 24 projects, only with up to 4 and it works ok).
The problem is with the slicers / pages that do not get a value, which is what happens in most cases.
I would like to be able to further control which pages get exported. I could make them blank if the sync slicer has nothing selected, but then the users would have to manually delete the slides in their .pptx or remove the pages on their pdf afterwards.
Does anyone have an idea on how to go around this? I could make all the pages visible if necessary. May be there is a "dynamically hide pages" option that Im not aware of? Or something that allows me to export a certain number of pages?
Any idea is welcome. So let's get creative! haha
Thanks in advance to everyone that takes on this challenge.