Displaying a prompt on report's initial load

[Former Member]

Hi,

I know that in WebI I can set a prompt to be displayed when the data is refreshed but that's not what I wish to accomplish at the moment. What I want to do is to display a prompt when the report is first loaded.

Example: As soon as the user opens the report, he's prompted with something like "Filter report with year <operator> <year>"".

Thanks for the help,

Joaquim

[Former Member]

Thanks guys for the great feedback!

[Former Member]

Hi Kuldeep,

Thanks for your response. I'm aware of the method you mentioned. But I'm trying to avoid having the report refreshed on open. Any other suggestions?

Thanks,

Joaquim

[Former Member]

Joaquim,

Kuldeep gave you the correct answer. You wrote:

Example: As soon as the user opens the report, he's prompted with something like "Filter report with year <operator> <year>"".

What you want is the local filter for the tab to apply a prompt based upon the data cached to that specific report (i.e. you want to save a report with the "refresh on open" off, but prompt on the static data). No can do. The prompt feature actually stages to construct an SQL statement, which in turns fires off a new query. There is no other prompt capability.

Thanks,

John

[former_member207342]

You can force report to be refreshed every time it opened this way it will ask user to enter values for prompts as soon as report is opened.

Right click on report ( in edit mode)

open Document properties

Check the "Refresh on Open" Check box.

reply if it does not works.

Regards,

Kuldeep