Report Studio: Cascade feature doesn't work like we expected 1

[shanmku]

Hi,

In one of our reports, we have three prompt pages. One of the pages contains prompts that is associated to one another.

So we have a heirarchy of prompts which has a parent and child relationship. Each of these prompts have an associated query where we have a detailed filter to check on the parent prompt selection.

Currently we have these prompts in the first page. So when we select a parent prompt, the child prompt is not getting populated. But if we press the next button and get to the next page. Then when get back to the previous page, it shows the selection correctly on both the parent and child prompts.

Is there a reason to this behaviour. Please suggest, Cognos Experts. Thanks in advance.

Regards,
Kumar S

 

[mfgf]

Hi,

The problem with having the prompts on the same page is in identifying when you have finished selecting items and want to submit. I'm assuming the prompts are Value prompts? If you select the first one of these, you will see a property called 'Auto Submit' - the idea is that if you set this to 'Yes', as soon as you select a value from the prompt the value will be automatically submitted, and the next prompt list will be populated. However, this cannot be set to 'Yes' unless the 'Multi Select' property is set to 'No', because it will submit after the first value is selected.

If you want to be able to select more than one value from the first prompt then submit these in order to populate the second prompt, leave 'Auto Submit' as 'No', 'Multi Select' as 'Yes' and from the toolbox, drag in a prompt button and drop it after your first prompt. In the properties of the button, set the 'Type' property to a value of 'Reprompt', then to relabel the button, drop a text item directly on top of it. This should now mean that the users can select the desired items from the first prompt then press the button to get the relevant list in the second prompt.

Hope that helps,

MF.

 

[shanmku]

Thanks a lot for your advice, MF. I followed the instructions and it works now like we expected. Also the report looks great.

Regards,
Kumar S

 

[Nuffsaid]

MFGF

Nifty "tip" about re-labeling prompt buttons.
Will certainly come in handy.

Thx


Nuffsaid.