I'm including two reports in a Business Insight dashboard. The first report includes a single list that displays summary data for different products, each product gets a single record in the list. The second report is a chart that is specific to one product, so it requires a parameter that allows for the selection of one product. I know this can be done by adding a prompt, either in the chart report or in a separate pane of the dashboard, but what I would really like is for the user to be able to click on a record from the first report, and have that modify the parameter of the second.
So far, I think I can get this to work though drill-throughs in the list, but that would cause the list report to reload, which I would rather not do.
Any suggestions?
rob