Ø Click on Reports tab and create a new report ‘Simple_Parameter’ .(Refer section 4 for detailed steps for creating the report.
Ø Using Query Builder generate the below query:.

Ø Now save the work done.
Ø Using Query Builder generate the below query:.
Ø Now save the work done.
- Creating a new Parameter
Ø Click on Parameter and click ‘New’ to create a new parameter.
Ø Give the name for the parameter.
Ø Edit the query to give the bind variable, i.e. the name of the parameter.
Ø Select the data type according to the parameter.
Ø If you want to give a default value give them and select the parameter type.
Ø Give the display label and text field size.
Ø Save the work done.
- Viewing the Output
Ø The default value will appear in the text box and by clicking ‘view’ the output is generated.

Comments
Post a Comment