Description When a user runs a report, he has to provide certain inputs. This interface is provided by the parameter form.
The Report Editor's Parameter Form view enables you to create a Runtime Parameter Form for your report. You can select pre-defined system parameters for your form using the Parameter Form Builder, or you can create your own.
The Report Editor's Parameter Form view enables you to create a Runtime Parameter Form for your report. You can select pre-defined system parameters for your form using the Parameter Form Builder, or you can create your own.
Now we will see how to design a parameter form:
We need to just drag and drop layout object from the tool palette.
Now we have to provide the source for the parameter. Click the parameter PF_2. This will open the property palette of the object. Now provide the source to the parameter. This source is the reference where the input has to be used.
Now provide the LOV (List Of Values) to the parameter. Also check for other properties like the datatype, width etc.,
Click the List of Values button, This will open the following window.
These LOVs can be designed in 2 ways
- Static list of values
- Dynamic list of values
Static LOV:
Provide static values, by directly entering the string.
Dynamic LOV:
These values are dynamically fetched from the database table columns.
Provide a sql statement.
The parameter form looks as below when running the report
By Default, the parameter form shows the first value retrieved from the DB. if you do not wish to show any value by default, check the "Hide First Column" option in the parameter List of values window.
