I am trying to create a report which has 2 pages - 1 a report from 1 package and 2 a reference to a report created using a different package. That isn't a problem. But I want to conditionally render only the page I ask for in the prompt. With the reference I do not see any options for this. It also doesn't allow me to put it into a Page Set. Anyone succeeded in something like this?
Thanks!
I got it to work. You take 1 report from one package and then use a Report Reference to another report which was created using a different package. Place the reference page as the first in the order - important not to get an empty page later.
Create a value prompt with 2 values (Query, Analysis) for example if your one package is query and the referenced one is Analysis. Use those values to create a Render Variable on the Report Page (not Reference page, not available) in the main report to only render when Query value is selected. On Analysis report itself (not reference to the report) create the same prompt and same render variable in that report for the report page doing that for value Analysis. Then save. Go back to your main report which contains a report page from Query and Report Reference to Analysis report, click on Report Reference and for the property of Prompt values use Merge option. Then run. The prompt page will come up asking for Query/Analysis, you select and should get the one you requested and nothing else.