This documentation page assumes that you already have a SeekTable account. Create your free account by signing up.

Report Parameters

Report parameters are used to customize a data query depending on the user-entered values. Common uses of parameters:

Also parameters are needed if you want to enable data filtering for published reports.
Note: interactive features for published reports (including inputs for parameters) are available only for accounts with advanced publishing subscription.

Parameters Setup

All possible report parameters should be declared in the Cube Configuration form:

Cube parameters setup

Each parameter should have an unique name; with this name you can use actual parameter value in datasource-specific query or in expression of another parameter. For more details about parameters usage in dataset query see help page for concrete data source.

It is possible to specify which UI editor to use for the parameter:

Textbox
Suitable for any kind of parameters. In case of multivalue parameter several values should be separated with comma ,
Checkbox
Used when in case of two-state parameters (like boolean true/false). Also can be used as a switch: depending on checkbox state other report parameter(s) may be applied in a different way.
Dropdown
Used when user can choose an option(s) from a pre-defined drop-down items. For non-multivalue parameter first entry should match parameter's default value (in most cases this is just an empty value).
Dropdown(dynamic)

Dropdown with dynamically-populated items list. Items may be loaded from some dimension of the parameter's cube or any other cube.

Technically data is loaded with internal pivot-table like report query that contains specified dimension(s). This guarantees only unique items in the dropdown. Another consequence is that this query result is cached for a short time like any other pivot table data.

Notice for reports that are embedded in a secure way: all report parameters that are passed in JWT payload may be used in dropdown-dynamic queries.

How end-user can enter report parameters:

Report Designer (inside SeekTable app)

Report designer: parameters tab

Published Report

Published report parameters
Note: inputs for parameters in pubished reports require "Advanced publishing" subscription

Calculated Parameters

In some cases you might need to modify parameter value before passing it to the query, and this is possible with Expression option. Typical usages:

Important: in parameter's expression you may use parameter values that are passed to the report with Parameter["param_name"]. Note that if specified parameter has own Expression you'll get an original parameter value and not a calculation result.