URGENT: Impromptu Prompt - calling one time

[SamG1000]

This should be a very easy question:
How would I crate a prompt and then use resulting value several times without calling this prompt over and over.

Thank you
Simon

 

[EpicXtreme]

SamG1000,

After getting the result from the first prompt, save that result into a txt file. Then create another prompt to select from a report file, it will then ask you where the report file is then you can point to the saved txt file. One thing to remember, only have one column saved in that report file. Also, if you use the "in" option with the prompt then you can select mutiple inputs from the drop down simultaneously instead of just one at a time. Hope this answers your question.

Regards, Carmelo Brual (IT Specialist)
Progress DBA
Cognos Impromptu Administrator
Cognos Impromptu Reporting

 

[SamG1000]

Carmelobr,

I would like to thank you for your response.
I also wanted to know if anyone knows a inbuilt way of calling multiple reports like -->"??prompt??"

Sincerely,
Simon Galperin

 

[SamG1000]

** correction for the post above **
Carmelobr,

I would like to thank you for your response.
I also wanted to know if anyone knows a inbuilt way of calling one prompt for multiple uses like -->"??prompt??"

Sincerely,
Simon

 

[griffindm]

Simon,

You haven't specified whether the multiple uses are in a single report, or over a series of reports called in sequence, which is where Carmelo's hint would help you.

Please be more specific and we'll see if we can help you.

Regards,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com

 

[SamG1000]

Dave,

I have used hotfiles, text files and other reports to build multiple prompts (one prompt is dependant on the other (cascading prompts))...

What I need is to call a prompt only once and then use its value in my filter several times Ex in the Filter dialog:

column1 = ?prompt1? and column2 = ?prompt1? and column3 = ?prompt1?

I need to make ?prompt1? show up only once!

If I am not wrong - using PL/SQL command: “??prompt1??” that could be achieved
Sincerely,
Simon

 

[EpicXtreme]

Simon,

Have you tried the calculation option. Create a new calculation and name it what ever you want. In here call your prompt, then use the result in your filters not the prompt.

Regards, Carmelo Brual (IT Specialist)
Progress DBA
Cognos Impromptu Administrator
Cognos Impromptu Reporting