ReportFormulaBar.OnGetDataAreaHint

Syntax

Sub OnGetDataAreaHint(Sender: Object; Args: IGetDataAreaHintArgs);

Begin

//set of operators;

End Sub OnGetDataAreaHint;

Parameters

Sender. The parameter that returns the component that generated the event.

Args. The parameter that enables the user to determine event parameters.

Description

The OnGetDataAreaHint event occurs on changing the text, which should be displayed next to formula bar.

Comments

The text displayed next to formula bar is generated on working with analytical data areas. The use of the OnGetDataAreaHint event argument provides possibilities to get or change displayed text. By default, the following text is displayed to the right of formula bar:

"Data source name! of name of elements that forms cell" if the cell containing formula is formed by data source elements. For example:

Cube of socio-economic indicators!Value|2001|Population|Administrative Region Leningrad|Regional data

"Empty" if cell is not referred to analytical data area.

Example

Executing the example requires a form with the ReportFormulaBar component named ReportFormulaBar1 on it, the ReportBox component named ReportBox1 and the UiReport component which is set as data source for ReportFormulaBar1 and ReportBox1. A regular report is connected to UiReport, analytical data area is created in the report.

Sub ReportFormulaBar1OnGetDataAreaHint(Sender: Object; Args: IGetDataAreaHintArgs);
Begin
Debug.WriteLine("Data slice: " + Args.Text);
End Sub ReportFormulaBar1OnGetDataAreaHint;

On occurring the OnGetDataAreaHint event, the console window displays information about elements that are used to build the current cell. For example, for cells from analytical area the following text can be displayed:

Data slice: = Cube of socio-economic indicators!Administrative Region Belgorod

Data slice: = Cube of socio-economic indicators!Value|2001|Population|Administrative Region Leningrad|Regional data