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

 

Default values for dynamically populated token prompt not applying after repromp

Started by hespora, 01 Dec 2015 04:06:47 AM

Previous topic - Next topic

hespora

Hi,


on my report page, I have two prompts:

1. value prompt, static choices of 4 different fields (MUNs I think i the term) from my data source (relational db, in case that matters). This one is auto-submit: yes.
2. value prompt, choices from a query with all 4 of those fields, plus a 5th data item using prompt token technique to populate with one of those 4 fields based on first prompts selection. This is the data item that the prompt uses.
Both prompts set to required.

The idea is that the report user chooses his field to filter on, then chooses values to filter on, hits reprompt, and gets his data. This works; the main query shows the correct data based on the user's selections.

What doesn't work is default values for the second prompt. I've populated that prompt's default selections with one value from each of the possible fields in there, and this works correctly upon the first page run (changing the default value on the first prompt and then rendering page shows that the correct default values are applied). However, when I change the selection on the first prompt, cognos auto-submits and then either renders the second prompt with no selection (which should be impossible, as it's setto required), or it shows me cognos' own prompting page (the one that shows up when you define a parameter without prompt for that parameter).

What am I doing wrong here? How do I get cognos to apply default selections correctly? (Also, if this seems more like insane drivel rather than a decent problem description, please do tell me ;))