Detailing Substitutions

It is available to set up alternative action for dimension elements in a table on a hyperlink click.

If the Open File or Open Link action is selected, one can use substitutions in the specified URL, which will be changed depending on the selected report element or parameter. One can set substitution for the Open Repository Object action using Fore to open various repository objects (example No.3).

Substitutions use dimension attributes, report parameters or report source parameters.

NOTE. Detailing substitutions are case-insensitive.

Dimension Attribute

It is set as: &[DIMENSION.<id>]

Where <id> is identifier of dictionary attribute.

Example 1

To open a link with a request to the search engine, one can use the http://www.google.com/search?q=&[DIMENSION.NAME] substitution.

If detailing is set for a dimension of observation objects, clicking the Vladimir Region element opens the corresponding search request.

Example 2

To open a file, one can use the &[DIMENSION.NAME].png substitution.

If detailing is set for a dimension of observation objects, clicking the World element opens the World.png file.

Example 3

One can set only one repository object for the Open Repository Object action. One can use Fore to set substitution to open various repository objects. To do this, keys or identifiers of opened objects should be stored in dictionary attribute values. The substitution for specifying attribute looks as follows: @&[DIMENSION.<id>]. If the opened object is parametric one, the substitution can be followed by parameter values in round brackets or parameter values can be passed using substitutions described below.

Create an event handler for report. In the OnBeforeRefreshEaxGrid event code get detailing settings for elements of the required dimension described by the IEaxDrillSettings interface. Set the IEaxDrillSettings.ActionType property to TabHyperlinkActionType.OpenObject, and in the IEaxDrillSettings.Action property set the substitution.

Examples of substitutions:

@&[DIMENSION.OBJ_ID] - to open objects, which identifiers or keys are stored in the OBJ_ID attribute.
@&[DIMENSION.OBJ_ID](A=10;B="Start") - to open objects and pass two fixed values for input parameters to them.
@[DIMENSION.OBJ_ID](PARAM0=&[OBJECTPARAM.PARAM0];PARAM1=&[OBJECTPARAM.PARAM1]) - to open objects and pass current object parameter values to them as input parameter values.

Regular Report Parameter

It is set as: &[OBJECTPARAM.<id>]

Where <id> is identifier of report parameter.

Data Source Parameter

It is set as: &[SOURCEPARAM.<id>]

Where <id> is identifier of data source parameter.

Example

To open a link, set the http://localhost/Object passport.html?dt=&[SOURCEPARAM.dt] substitution.

In this example dt is a parameter of the object passed to web page parameters.