Hi All,
I have a report with list, prompt and graph. When I click on list with category it has to drill through to same report to show subcategories in a prompt and graph with All categories. When I am making a selection on the subcateg prompt and the graph filters, but on clicking the categ selection on list the prompt doesn't get refreshed to showall instead it retains the previous selection. how do I refresh this prompt parameter?
btw: it works when the drill through is set to open in a new page.
Regards,
resolved this. This is how I did it.
Categ list from which I drill through to subcateg prompt and graph on same page. In drill through on same report I selected 'Do not pass parameters' for subcateg data item value in parameter passing. This will allow you to refresh the subcateg prompt on same page to show "All" each time you navigate between different categories.