Report Author 10.2.1 and Prompts On the Body of the Report

[gosoccer]

Hi everyone, :)

I have a new requirement to have the Date Prompt on the same page as the report body page.

Is there a good practice to use to do this?

Thx so much for your time.

[BigChris]

It's quite easy to do - just bring it into the header and put in a reprompt button as well. I tend to add a render variable based on the reportoutput so that if you run the report out to excel (for example) it doesn't show the prompts.

[gosoccer]

Hey, could you be able to share some of your code. I'm hitting a crazy deadline taking vacation time to work. I'm familiar with rendering using a Block to check a variable and hide the block. I'm just not sure how to do it in this case. thx so much! :) :)

[BigChris]

It's exactly the same principle - set up a variable with something like:

ReportOutput() not in ('XLS', 'CSV')

[gosoccer]

Ahh! That is tricky! OK, I'll try it. Thx so much. I owe you one!

[gosoccer]

YES YES. I think I got it. Now, I have to figure out how to change the label of "Reprompt" to Search.

Thx so much.  :) :)

[cognos810]

Drag and drop a text item on the button. Set the text as Search.

[gosoccer]

Thx so much! That worked!! :)

[gosoccer]

Now, thats wierd. I'm getting a prompt page coming up even though I have no prompt page.
After selecting this initial prompt page (see attached) it works just fine.

Do you by any chance know how to turn this prompt page off. I'll keep digging and please don't feel you need to answer since you have been very helpful.

Thank you,

[gosoccer]

No worries, I just set the filter to Optional in the Query since they are dealing with Reprompt anyway.

Thanks alot :) :)

[cognos810]

That is the expected behavior :)
If you have a required filter in the query and you have not provided a prompt page with a prompt UI associated with that parameter, it will prompt you for the value, for the query to return results. Setting it as optional is one way to do it. The other way, if you have to keep it as required and at the same time do not want it to prompt you when the report runs, then on the prompt UI on the Report page, provide a default value for it.

-Cognos810

[gosoccer]

Ok, Great. That makes sense. I tried anything I could to turn it off. Well, I keep it optional for now. Thx in advance for your time.