If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

drill thru on same report doesn't refresh prompt parameter

Started by sukanya, 08 Aug 2017 09:22:11 AM

Previous topic - Next topic

sukanya

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,

sukanya

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.