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

 

Using filter parameters of the previous run: case of conditional block in prompt

Started by Severin, 20 Mar 2017 06:23:35 AM

Previous topic - Next topic

Severin

Requirement: When re-running the report, the user wants to keep filter values selected during the previous execution without being obliged to navigate between all filter pages. How can we manage this? any idea or code Javascript?

Briefing: the report concerned is composed of:
-   A List of columns
-   A prompt page composed of: Value Selection Prompt: Each value refers to a filter page + New prompt button + Conditional block: Each block contains a filter page. It is managed by a conditional variable. And this one takes the value of the prompt parameter.
Detail of the problem: In the first execution, the user enters several prompt parameters in several pages. He navigates between blocks; by selecting the page in Value Selection Prompt then by pressing new prompt button. Cognos runs the report and displays the data list. When the user wants to run the report another time, cognos redirects him to the last selected filter page. If you navigate through the other prompt pages, you will find that all previously selected filters are backed up by Cognos. But it is necessary to pass through these filter pages so that the value of the prompt parameter is taken into account in the data list. Otherwise, the parameters are not considered.

PS: The choice of using filter pages in a conditional block is justified by the customer refrain from going through all the pages. Otherwise we would have created many prompt pages and use cognos buttons 'Previous' and 'next'. any other proposition is more than welcome.

We use cognos version 10.2.1

Thanks in advance for your help.

New_Guy

Hi,
Have you thought of creating reportviews for each combination, if they are not that many combinations. And also inline pormpts is another way depending on the situation.
When it comes to find a way by using java script, Cognos Paul is the one who can answer.
Good luck
New Guy

Severin

Hi,
Thanks for your quick reply!!
Using Reportview is not conceivable for this case. We're talking about 5 filter pages with more than 10 parameters on each page, plus multiple users.
I want to understand where cognos back up the filter values of previous run (param caching maybe), and how can we get these values without accessing the pages.