Skip to Content
author's profile photo Former Member
Former Member

Displaying a prompt on report's initial load

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Aug 21, 2009 at 12:31 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2009 at 01:00 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2009 at 02:37 PM

    Thanks guys for the great feedback!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.