Is it possible to fetch the value selected by the user while the prompt is shown before running the report?
If it is then how can it be done,
Thanks in advance.
You could have a Reprompt button to refresh the prompt page (by selecting "Reprompt" from the type property of a Prompt Button) and then also have a Finish button to run the actual report.
To actually display the values selected, you would need to drag a Layout Calculation onto a page, and below the Available Components area there are three tabs. If you navigate to the Parameters tab, you'll see any predefined parameters that you have already created. Dragging this into the Expression Definition box will then show ParamDisplayValue ('prompt_name') which, at run time, will display the selections that have been made for whatever your parameter name is.
I need to pass the values to a drill down report. I don't need to display it.