Action link to report on same dashboard

Question

Hello,

I have a dashboard with an overview of an amount of orders per day for the next week. I would like to use an action link to go to a more detailed report on what is going to arrive at a particular day. But I would like the detailed report to appear on the same dashboard and only to appear when I click on a particular day and display the details for that day. How do I configure this?

Regards,

Lianne

Jerry Casey · Answer

I've had a lot of problems with master-detail linking across separate reports.

I have had success using an action link in the base report that navigates to the same dashboard page.  A hidden prompt (in dashboard properties) populates a presentation variable that filters the second report.  The presentation variable has a bogus default value that prevents any action until the action link is clicked.  A condition on the section containing the second report can hide/reveal it.

Gianni Ceresa · Answer

Hi,

Based on your thread master-detail, as suggested by ArijitC, would be the natural answer except for a detail: you want the detail to be visible only after clicking on a day. Master-detail is more that the detailed analysis is always there and master-detail will filter based on the click.

An alternative way based on what you ask could be a normal action link, but cheating a bit to display the detailed analysis. You can set a condition to hide/show the section of the page containing the detailed analysis. The idea is to use the condition to check if a day is set/passed as selected or not.

In that way you would achieve what you ask for, just by cheating a bit on the show/hide of the detailed analysis.

Robert Angel · Answer

From memory I think you can put a hidden section on a page and navigate to it, but this is sometime back, so I could be wrong? (anyone done this - is my memory playing tricks?!)