Had a situation where I need to develop a detail report for a dashboard based on the prompts selected in that dashboard.
Dashboard had multiple summary lists/crosstabs/charts
below are high level steps.
Solution:
1. develop a detail list report based on the same prompts.
2. At master report
- create a singleton (on the dashboard where you want to see the url)and say you assigned it to query – q_detail.
- Create a data item say “Detail data” and with value “click for detail data”
- now add this data item to the singleton you created.
- select the data item in the singletom and select drill-Through definitions.
- select required report and other options. At parameters click on edit sign and use
- “Pass parameter value” and select associated prompt name.
- click ok.
now when you run the summary report you should see a link “click for detail data”