NOTE: You can only perform these tasks for simple reports.
When you create a simple report in Manager, you use the VI_Report_DefaultTemplate report is used as a template. This report does not contain any report parameters itself. To use report parameters in the report definition of simple reports, you can add the report parameters in the Manager. You can remove report parameters that are no longer needed.
To add a report parameter
-
In Manager, in the Report Subscriptions > Subscribable Reports category, select the subscribable report.
-
Select the Change main data task.
-
On the Parameters tab, select the Add button.
-
Enter the report parameter's main data.
-
Click Save.
To remove a report parameter
-
In Manager, in the Report Subscriptions > Subscribable Reports category, select the subscribable report.
-
Select the Change main data task.
-
Select the report parameter on the Parameters tab in the upper section of the main data form.
-
Click the Remove button.
-
Click Save.
Related topics
Enter the following general parameter settings.
Table 8: General parameter settings
|
Parameter name |
Parameter name. |
|
Parameter type |
Type of parameter. Permitted values are:
-
Fixed: Fixed parameter values are used. On the Value definition tab, enter the parameter value.
-
User prompt: The user must select a parameter value in the user prompt at runtime.
-
Calculation: The parameter value is calculated at runtime when the report is created. On the Value calculation tab, enter the table column and the condition for calculating the value.
Other settings are shown or hidden depending on the type. |
|
Display name |
User friendly name for the parameter. To display language dependent display names, translate the given text with the  button. |
|
Description |
Text field for additional explanation.Translate the given text with the button. |
|
Sort order |
Position of the parameter in the subscribable report view and in the Web Portal. |
|
Mandatory parameter |
Specifies whether this is a mandatory parameter. You must give a value for a mandatory parameter. |
|
Viewable |
Specifies whether the parameter is shown when a report subscription is set up in the Web Portal. |
|
Can be overwritten |
Specifies whether the parameter can be overwritten by Web Portal users when a report subscription is created. |
Use the value definition to specify the parameter value and define the characteristics of the parameter value. Other input is shown or hidden depending on the parameter definition values.
NOTE: Parameter value and Default value are heavily influenced by the parameter value definition. This is shown, on one hand, by dynamic customizing of the controls available for the parameter value and default value, and on the other hand, by dynamic customizing of the values available themselves.
That is why it is recommended to edit the parameter definition first assuming this is necessary.
Enter the following data for a parameter definition:
Table 9: Value definition
|
Data type |
Parameter data type. |
|
Date add-on |
Additional information about calculating date and time data for displaying in the user interface. The value can be edited if the Date data type is selected. |
|
Value range |
Specifies whether the report parameter value has to be within a given range. If Yes, additional fields appear. |
|
Multivalue |
Specifies whether the parameter accepts multiple values. If Yes, users can select multiple value from a list. |
|
Multiline |
Specifies whether the parameter contents can have multiple lines. If Yes, line breaks are permitted. |
|
Data source |
Type of data source. Permitted values are:
-
None: The user can give any value.
-
Table: The user selects a value from a specified table column.
-
List of permitted values: The user selects a value from a predefined list.
You may require additional data depending on the data source. |
|
Table column (query) |
Additional data for the data source Table.
Table column for selecting the parameter value. The user can select a value from this table column. If the parameter is multi-value, you can select several values from this column as well. |
|
Display pattern |
Additional data for the data source Table.
Display pattern for table elements in lists in %column% notation. The ?? operator is permitted. This means, when one column's value is empty, another column's value is displayed.
Example: %column1??column2??column3% |
|
Condition (query) |
Additional data for the data source Table.
Limiting condition (Where clause) for selecting the parameter value using a table column. The user can select a value from the result set. If the parameter is multi-value, you can select several values from this result set as well.
You can reference other parameters in the condition using the following syntax:
$PC(<Parametername>)$
Example:
UID_Database = $PC(UID)$
where UID is the name of the referenced report parameter. |
|
List of permitted values |
Additional data for the data source List of permitted values.
List of values permitted in this parameter in the value=display name notation. If an = is no given, the entry counts as both value and display name.
Example: 1=internal 2=external
To display language dependent display names, translate each display name using the button. |
|
Overwrite empty value |
Specifies whether an empty parameter value overwrites the default value.
If this option is disabled, the default value is overwritten if a parameter value is not given. |
|
Parameter value |
Parameter value If a value range is given, the Parameter value (from) and the Parameter value (to) are displayed. |
|
Example value |
Example of the parameter. The example value is used to create a report preview.
If a value range is given, the Example value (from) and the Example value (to) are displayed. |
|
Default value |
Default value of the parameter. This is used if the user does not specify a parameter value and the Overwrite empty value option is not set.
If a value range is given, the Default value (from) and the Default value (to) are displayed. |
Enter the following data if the report parameter is calculated:
Table 10: Scripts for calculating values
|
Table column (calc.) |
Additional input for Calculated parameter type.
Table column for selecting the parameter value. The parameter value is determined at runtime when the report is created. |
|
Condition (calc.) |
Additional input for Calculated parameter type.
Limiting condition (where clause) for selecting the value through a table column. The parameter value is determined at runtime when the report is created. If the parameter is multivalue as well, several values may be found.
If a condition is not given and the parameter is not multivalue, the first value is used that is determined by the table column. If the parameter is multivalue and a condition is not given, all determined values are used. |
|
Valuation script |
Script in VB.Net syntax for modifying the parameter value. The script can be used as a formatting script and the existing parameter value modified or reset the parameter value. |
|
Validation script |
Script in VB.Net syntax for checking permitted values of parameters. Create a script that checks the user input. |
|
Data dependencies script |
Script in VB.Net syntax. The script allows parameter settings to be configured depending on the data. It is run during initialization and when values are changed. For example, the script can be used to dynamically determine whether a parameter is read-only or mandatory.
Example:
The P2 parameter should be a mandatory field when the P1 parameter has the value Mandatory field. The following script must be stored with the P1 parameter:
ParameterSet("P2").IsMandatory = (Value IsNot Nothing AndAlso Value.ToString() = "Mandatory") |
