Export: Prompt Selection Display

[WKar]

Hello-

I have Value Prompts on the Prompt Page & the same prompts on the Report Page itself in report studio.  I want to be able to export the report in Excel and have the Prompt Selection be Displayed on the Exported Report.  How can I do this? 

Thanks in Advance

[Suraj]

ParamDisplayValue('PromptName') will display prompt value in a report expression.

[WKar]

Ultimately my goal is for the text to display where the prompts were when running the report. 

I know with a data item you can put that report expression in the expression box, but what about a value prompt?  Do I HAVE to create a data item and place it on the report the only way to accomplish this?  Because when it is not exported and just ran with the Cognos Viewer, I dont need it displayed on the report because the prompts are on the page as well. 

thanks for your response

[Suraj]

It doesn't matter whether you have prompts in your page or not.
As long as there is value selected and submitted in the prompts, ParamDisplayValue('PromptName')  displays it.
But you have to have a selection submitted.
It can be a text item as report expression anywhere in the page to display selected value.