Report Parameters

The report parameters allow for the parameterization of reports; i.e. the result of the output can be influenced. This allows e.g. a date range to be selected or only certain invoice numbers to be printed.

This functionality can also be used to create drill-down reports. For more information, see chapter Drilldown Reports (Increase Detail Level).

Tip: The availability of this chart depends on the application.

Parameters can be defined via Report Parameters.

 

Property

Description

Value

Description

Name

Name of the report parameter

Text

 

Depending on

Report parameter with data source which this parameter is implicitly depending on. The 'parent' parameter must preceed the depending parameter in the report parameter list.

 

Text

 

Available Values

Source for the possible values of the parameter

 

From Data Source

From Predefined Values

Manual Input

 

Data Source

(From Data Source)

The name of the data source for the values.

 

 

 

Filed for Value

(From Data Source)

Field selection for the parameter value for usage in formulas or filters.

 

 

 

Sort Order

(From Data Source)

The desired sort order of the data.

 

 

 

Data Filter

(From Data Source)

Undesired selection values can be filtered with this function.

True

False

Formula

Yes

No

Formula wizard

 

Type

(From Predefined Values)+(Manual Input)

Value type of the parameter.

 

Boolean

Date

Numeric

Text

 

Values

(From Predefined Values)

Please enter the available values here.

 

List

 

Format

(From Data Source)+(From Predefined Values)

 

 

 

Displayed Value

(From Data Source)+(From Predefined Values)

Formula for displaying the value in the selection list. If the formula is empty, the value will be displayed directly.

 

Formula wizard

 

Validation Expression

(Manual Input)

Regular expression for validation of the entry..

 

Formula wizard

Default

Use all possible values or particular values as default?, e.g.. Year(Now()), Year(Now())-1.

True

False

All

Values

May Be 'Null'

True

False

Yes

No

May Be Empty

True

False

Yes

No

Support Multi Selection

Enable multi selection.

True

False

Yes

No

Apply immediately

Changes to this report parameter are applied immediately without pressing the button to recreate.

True

False

Yes

No

Control Type

Type of the control for entering the parameter.

 

Boolean (True/False)

Boolean (Yes/No)

Date

Date with Time

Text

Description

Description text for the parameter. The text will be used as label for the input control of the parameter.

Text

Formula wizard

Help Text

This text appears in various locations, for example in the variables/fields list and as tooltip help text of the control.

Text

 

Visible

The parameter is visible in the preview.

True

False

Formula

Yes

No

Formula wizard