Generate Parameter
Input parameters can be specified for a report, using the Generate Parameter link in report editing screen.
Select “Generate Parameters” activity under “Report Definition”.
Click on the ‘Generate Parameters’ link it will launch the screen.
Apply Generate Parameters |
Default value is No. if choose the option ‘Yes ‘will auto generate the Parameter screen from the configuration information given in screen. |
Choose the option “YES", it will launch the screen.
Input Parameters |
List report SP in-param details. |
Control type |
System generate 3 types of controls namely Combo/Date Control/ Text Input / None. |
Parameter Source type |
It can be either stored procedure or query. This type does not require For Text Input control. |
Stored Procedure name |
Type the stored procedure name. |
Event Loading on change of |
Choose Initialize by default, if dependent combo, choose the BT |
An Input parameter of type combo can have a Query or Stored Procedure attached to load the Data values on load.
To attach the stored procedure, write the “SP”.
To attach a Query, select the “Query” option.
Click “Save” to create schedule.