Hi
I have a report with a number of cascading value prompts with autosubmit set to no
Because of the fields, when you first run the report it takes ages to display everything, then using the prompts you narrow the report down
To try and speed up the initial display, I have put a default selection on the first prompt which does the trick. However it would be better if when you first run the report no data was displayed then when you make a selection on your first prompt and press NEXT the report displays the selected data.
Is this possible ?
thanks
Mike
Hello MikeG,
Yes, use render variables to not show your report query containers like list,crosstab, charts etc that you may have on the report. The condition for the render conditional BOOLEAN variable should be ParamValue('<YourParameterName>') IS NOT MISSING. Then render the object for "YES" value. In essence, the query will not be executed and the object not rendered unless you select a value in the prompt button.
-Cognos810
i used to have this requirement from an ahole boss. he do not want a prompt page but actually the report behavior is like having a prompt page.
so create a prompt page with the normal prompts, but also put a screenshot of the report without data. it will give the impression, the report has run with no data in initial display, while you are filling in values to your prompt.
Hi,
Used method advised by Cognos 810 and it did the trick
thanks for help
Mike