[IFS/BA Designer Help Guide]
Apply Parameters
Explanation
This activity is used to select or enter values which are used to filter the
information shown in a report when being processed. This filtering can be done
using the Filter Criteria
tab where you can select the parameter values using the List of Values.
Prerequisites
In order to assign parameters:
- Parameters should have been created.
- Ensure the basic design of the report has been created.
- The report created should be filtered to use the created parameters.
System Effects
Information filtered using the parameters will be displayed in the report
when executed. If the report is saved as a template or as a published report and
is retrieved at a later time, it will only display the filtered information.
Related Process Model
Apply Basic Design
Related Activity
Select Information
Sources
Procedure
To create a standard parameter
- Click Report Book.
- Click Parameters.
- Select Standard Parameters tab.
- Click
New Parameter.
- Select the Visible check box if you want the parameter to be
visible to the end user. If this is not selected you must enter a
default value to be used when filtering using this parameter.
- Select the Editable checkbox if you want the parameter value to
be editable during report processing.
- Select the Multi Value check box if you want to enter multiple
values for a parameter. Multi value parameters can be used as a condition
for a Filter Criteria with operator IN or NOT IN.
- By default a parameter is Mandatory, i.e. it must be supplied at report execution to ensure a meaningful report execution. This is
especially important when a report is published to IFS Reporting.
- The parameter type will be set to DisplayItem by default but can be changed according to
the needs. Selecting DisplayItem means the parameter is connected to a display
Item. The parameter value can also be represented by:
- a constant string value by selecting StringConstant
- a constant number value by selecting NumberConstant
- a constant date value by selecting DateConstant. Note that this type can be used to define a parameter that provides the date and time when the report was executed. Define the
Default Value as #NOW# (Context Substitution Variable).
- Enter a name for the parameter. Once the user enters a name for the Parameter,
Description and Prompt Text Fields will be automatically set to the Parameter Name which was entered.
-
Select a Display Item to represent the parameter.
- Select a value, parameter, context substitution variable or global parameter from the List of Values dialog box for the Default Value, if required.
- Select a value for the Copy Value From field to use a value of another parameter, if required. When a value is entered to this field, the Default Value which has been set to the parameter currently
will be removed
Note: When a parameter is saved it becomes visible in the
Display Parameters
pane. By expanding the parameter, it is possible to drag and drop the parameter
name, parameter value and any additional display items in to the design sheet.
To create a function parameter
- Click Report Book.
- Click Parameters.
- Select Function Parameters tab.
- Click New Parameter if you need to create a new parameter.
- Fill the Parameter Name field for the newly created parameter.
- Select a Function Id from the available functions. If the Advanced Function check box is not selected, you will only get the
available simple functions in the List of Values dialog box. If the Advanced Function check box is selected, you will also get set of advanced functions in the list as well.
- Function Argument section will be updated soon after you select the Function Id.
- You can also provide suitable values for function arguments. They can be a context substitution variable, other parameter or a direct value.