1

Topic: Cognos 8 and setting of parameters of the report by default

Hello, colleagues! Cognos 8. Somehow it is possible to set in Value Prompt on the options page (Prompt Page) the values of parameters selected from a DB?
Default Selections allows to set manually only specific values. And I need to install values from the request.

2

Re: Cognos 8 and setting of parameters of the report by default

Mr. the Hat;
it is possible to try to create
1 report which receives your parameters default
In it to write the code to launch performance
2 reports with transmission to it of parameters of 1 report.
P.s.  years 5 did not develop under Cognos, forgot already much.

3

Re: Cognos 8 and setting of parameters of the report by default

Though it is possible and is easier.
The report on procedure returning the cursor and if parameters are not transferred to a report input to use yours by default, the procedures defined in the code.

4

Re: Cognos 8 and setting of parameters of the report by default

SpellBuilder;
I your idea did not understand Something. How parameters from stored procedure get on promt page? Or in case of the cursor promt-kontroly take the first values from a data set?

5

Re: Cognos 8 and setting of parameters of the report by default

Mr. the Hat;
It is possible to make two parameters: param1 and param2 (the second - hidden, for  parameters)
By means of JS all values in param2 are selected
Further we check, if there are selected values in param1 it is used param1, differently use param2

6

Re: Cognos 8 and setting of parameters of the report by default

Serene;
To fill by means of JS? I will try.