Can I display Run-time values in the report? 3

[Oradam]

Hi All,
When my report runs, the user is asked to provide several pieces of data before the report generates. For instance, it will ask for a start month and an end month via the @Prompt(,,,,) method. Is there any way to then display the start and end months they chose in the report itself?
Thanks for your help!
Adam

 

[BobWard]

Use the UserResponse function to create yourself a variable. something like

= UserResponse(NameofDataProvider,"Enter Start Month&quot

You can either hardcode the NameofDataProvider required for parameter1 or user the DataProvier function to return the name of the data provier based on a object passed as a parameter

 

[Oradam]

another quick question for you - is there any way to take that value the user entered in and that i fetched from the UserResponse function and send it through an Oracle Stored Function? The user enters a number at report run-time and I need to look up the name associated with that number and show it on the report. Thanks again for all your help.
Adam

 

[BobWard]

Dont see why not. You can define objects which call stored procedures, passing parameters. If you define the object and use the @Prompt function with the same text as the prompt in the report as the parameter to pass it should do the job.

Could an object not just return the text description anyway without calling a stored procedure ?

 

[incentive]

how to use stored procedure in BO ?
It gives an error when you set input/output parameter,so what to do?