Defines whether you want to load CSV file from the local file system (true) or not (false). Default value is false. Only for CSV data source type.

The data source catalog name of the OLAP data source (only for DataSourceType.MSAS, DataSourceType.MONDRIAN, DataSourceType.ICCUBE, DataSourceType.ACTIVE_PIVOT, DataSourceType.SAP data source types).

Selected measure on charts view.

Selected tuple index on the Pie chart.

Indicates whether the range of values on the charts is selected automatically or not. Default value is false.

Indicates what column should be used for x axis labels in Flat Table charts. User can choose it from UI and it will be saved in report's chartLabelsHierarchy property. If it is empty, row numbers will be used. Default value is empty string.

Indicates whether to show multiple measures on charts. Default value is false.

Title of the chart.

Selected chart type. The following chart types are supported: ChartType.BAR, ChartType.LINE, ChartType.SCATTER, ChartType.PIE, ChartType.BAR_STACK and ChartType.BAR_LINE (starting from v1.9).

Defines whether pivot table should be shown in the classic view (true) or not (false). Default value is false, which means that classic view is turned off.

It is used to save and restore columns width in report.

A list of hierarchies in the "Columns" axis. Each object has the following properties:

• caption - String, hierarchy caption
• dimensionName - String, dimension name
• filter - Object with the information on filtering:
  • members - Array of hierarchy's members to be reflected/shown according to the applied filter;
  • negation - Boolean. Represents the filter on hierarchy's members. It tells the component to show the members of hierarchy specified in items (true) or to show all the members of hierarchy except the items (false); (This property has been added in version 1.7)
  • measure - String. Represents the filter on values. The name of the measure on which Top X or Bottom X filter will be applied.
  • quantity - Number. Represents the filter on values. Number of elements to choose for the Top X filter if type is 'top' or for the Bottom X filter if type is 'bottom'.
  • type - String. Represents the filter type applied to the hierarchy. It can be: 'none' - filter is not applied to the hierarchy, 'members' - the filter on hierarchy's members is applied, 'top' - the filter Top X is applied on values, 'bottom' - the filter Bottom X is applied on values.
• sortName - String, sorting type for the members (SortType.ASC, SortType.DESC or SortType.UNSORTED)
• uniqueName - String, hierarchy unique name

It is used to save and restore columns width in report.

Describes sorting on columns. Object has 3 properties:

• measure - String, measure unique name
• tuple - String, defines the tuple
• type - String, sorting type (SortType.ASC, SortType.DESC or SortType.UNSORTED)

See also

Array of objects. Each object can have 3 properties:

• column - Number, default is -1
• row - Number, default is -1
• formula - String, formula

Indicates whether the Fields List is opened (true) or closed (false).

Indicates whether the Fields List toggle button is visible (true) or not (false).

Indicates whether the Fields List will be the same height as the component (true) or it's height will be defined by its content amount (false). Default value is false.

Given catalog's cube's name of the OLAP data source (only for DataSourceType.MSAS, DataSourceType.MONDRIAN, DataSourceType.ICCUBE, DataSourceType.ACTIVE_PIVOT, DataSourceType.SAP data source types).

JSON data

The service info of the OLAP data source (only for DataSourceType.MSAS, DataSourceType.MONDRIAN, DataSourceType.ICCUBE, DataSourceType.ACTIVE_PIVOT, DataSourceType.SAP data source types).

Type of data source.

See also

Default value is "dd/MM/yyyy".

Default value is "dd/MM/yyyy HH:mm:ss".

Sorting type for hierarchies' members (SortType.ASC, SortType.DESC or SortType.UNSORTED). Default value is SortType.ASC.

See also

Indicates whether all levels of all hierarchies in slice will be drilled down (true) or drilled up (false).

Array of objects. It is used to save and restore drilled down columns.

Array of objects. It is used to save and restore drilled down rows.

Indicates whether the drill through feature is enabled (true) or disabled (false). User can drill through by double-clicking the cell with value. This feature is available for CSV data sources only. Default value is true.

Indicates whether the editing feature is enabled (true) or disabled (false) on the Drill Through popup for CSV data sources. User will be able to double-click the cell and enter new value in it if the editing feature is enabled. This feature is available for CSV data sources only. Default value is false.

Defines whether config file contains the data source.

Indicates whether all nodes in the data tree will be expanded (true) or collapsed (false) on the grid and on charts.

Array of objects. It is used to save and restore expanded columns.

Array of objects. It is used to save and restore expanded rows.

Defines specific fields separator to split CSV row (only for CSV data source type). There is no need to define it if CSV fields are separated by , or ;. This property is used only if another char is used.

The URL to CSV file or to server side script which generates CSV data (only for CSV data source type).

Indicates whether the gridlines are shown for all cells (false) or only non-empty (true).

Defines whether data should be shown in the flat view (true) or not (false). Default value is false, which means that flat view is turned off.

Array of FormatValueObjects which contains formatting parameters.

See also

Title of the grid.

Footer in HTML format which is added to exported HTML.

Header in HTML format which is added to exported HTML. The following tokens can be used: ##TITLE##, ##CURRENT-DATE##. They will be replaced by appropriate data.

Indicates whether the line breaks in quotes will be ignored (true) in CSV files or not (false). Default value is true, which makes CSV parsing faster. Set it to false only if your data source has valuable for you line breaks in quotes. Please note that this might slow down CSV parsing a little bit.

The language id for data source (only for DataSourceType.MSAS data source type).

Specifies the path to localization file.

Specifies transparency of the logo. Value from 0 to 1. Default is 0.3.

Specifies URL to the company's logo.

Array of objects. A list of the selected measures in the report. Each object has the following properties:

• aggregation - String, unique name of aggregation applied to the measure (AggregationName.SUM, AggregationName.COUNT, etc.)
• caption - String, aggregation name which will be shown on the aggregations selection control
• format - String, name of number formatting
• uniqueName - String, measure unique name

See also

Array of objects. A list of hierarchies in the "Pages" ("Report Filter") axis. Each object has the following properties:

• caption - String, hierarchy caption
• dimensionName - String, dimension name
• filter - Object with the information on filtering:
  • members - Array of hierarchy's members to be reflected/shown according to the applied filter;
  • negation - Boolean. Represents the filter on hierarchy's members. It tells the component to show the members of hierarchy specified in items (true) or to show all the members of hierarchy except the items (false); (This property has been added in version 1.7)
• sortName - String, sorting type for the members (SortType.ASC, SortType.DESC or SortType.UNSORTED)
• uniqueName - String, hierarchy unique name

Specifies the path to the external font (TTF) which will be used during exporting to PDF. This is optional. Default value is "".

Footer in HTML format (only limited amount of tags are supported: div, p, span, br, img with base64 src, some basic inline styles) which is added to each page of exported PDF. The following tokens can be used: ##TITLE##, ##CURRENT-DATE##, ##PAGE-NUMBER##, ##TOTAL-PAGES##. They will be replaced by appropriate data.

Header in HTML format (only limited amount of tags are supported: div, p, span, br, img with base64 src, some basic inline styles) which is added to each page of exported PDF. The following tokens can be used: ##TITLE##, ##CURRENT-DATE##, ##PAGE-NUMBER##, ##TOTAL-PAGES##. They will be replaced by appropriate data.

The path to proxy URL to the OLAP data source, such as Microsoft Analysis Services, Mondrian, icCube, ActivePivot (starting from v2.0), SAP BW (starting from v1.9) (only for DataSourceType.MSAS, DataSourceType.MONDRIAN, DataSourceType.ICCUBE, DataSourceType.ACTIVE_PIVOT, DataSourceType.SAP data source types).

Defines which char is used in CSV to denote the end of CSV row (only for CSV data source type). Default value is "\n".

It is used to save and restore rows height in report.

It is used to save and restore rows height in report.

Array of objects. A list of hierarchies in the "Rows" axis. Each object has the following properties:

• caption - String, hierarchy caption
• dimensionName - String, dimension name
• filter - Object with the information on filtering:
  • members - Array of hierarchy's members to be reflected/shown according to the applied filter;
  • negation - Boolean. Represents the filter on hierarchy's members. It tells the component to show the members of hierarchy specified in items (true) or to show all the members of hierarchy except the items (false); (This property has been added in version 1.7)
  • measure - String. Represents the filter on values. The name of the measure on which Top X or Bottom X filter will be applied.
  • quantity - Number. Represents the filter on values. Number of elements to choose for the Top X filter if type is 'top' or for the Bottom X filter if type is 'bottom'.
  • type - String. Represents the filter type applied to the hierarchy. It can be: 'none' - filter is not applied to the hierarchy, 'members' - the filter on hierarchy's members is applied, 'top' - the filter Top X is applied on values, 'bottom' - the filter Bottom X is applied on values.
• sortName - String, sorting type for the members (SortType.ASC, SortType.DESC or SortType.UNSORTED)
• uniqueName - String, hierarchy unique name

It is used to save and restore rows height in report.

Describes sorting on rows. Object has 3 properties:

• measure - String, measure unique name
• tuple - String, defines the tuple
• type - String, sorting type (SortType.ASC, SortType.DESC or SortType.UNSORTED)

See also

Indicates whether the aggregation selection control is visible (true) or not (false) for measures on Fields List. Default value is true.

Defines the visibility of "Add calculated value" link in Fields List. Default value is true.

Indicates whether the button to show/hide the legend on charts is visible. Default value is false which means that the legend is always visible, without the button that hides it.

Indicates whether all dropdowns on the top of charts are visible (true) or not (false). The property can be used to show simple chart without controls or when you want to save space. The dropdowns are visible by default (true).

Indicates whether the warning are shown if data is too big for charts. Default is true.

Indicates whether to show zero values on charts (true) or not (false). Default value is true. Default value is true.

Defines whether the component selects a default slice for the report with empty slice (when nothing is set in rows, columns, pages and measures). If true, the first hierarchy from data goes to rows and the first measure goes to columns in the default slice. To avoid this default behavior, please set this property to false. Default value is true.

Indicates whether the opening columns/rows filter controls and page filter controls are visible (true) or not (false) on the grid. Default value is true.

Indicates whether the opening columns and rows filter controls are visible (true) or not (false) on the charts. Default value is true.

Indicates whether the filters info will be shown (true) in exported Excel file or not (false). Default value is false.

Specifies how to show grand totals: in rows ("rows"), in columns ("columns"), in rows and columns ("on") or hide them ("off"). Default value is "on".

Indicates whether the spreadsheet headers are visible (true) or not (false).

Specifies how to show drillable hierarchy cells on the grid: with link on the right (true) or with icon on the lift (false). Default value is false.

Indicates whether the hierarchy captions are visible (true) or not (false) on the grid. Default value is true.

Indicates whether the member properties for OLAP data source are visible (true) or not (false) on Fields List. Default value is false.

Indicates whether the reports filtering cells on the grid should be visible (true) or not (false). Default value is true.

Indicates whether the totals are visible (true) or not (false). Default value is true.

Indicates whether the sorting controls are visible in rows ("rows"), in columns ("columns"), in rows and columns ("on" or true) on the grid cells or not visible ("off" or false). Default value is "on".

Specifies URL to CSS file.

Indicates whether the values from MSAS data source will be formatted according to the format defined in the cube (true) or not (false). Default value is false.

Type of view to show: ViewType.GRID, ViewType.CHARTS or ViewType.GRID_CHARTS (starting from v1.9).

The value of zooming. The value can be from 0.25 to 10. Default value is 1.

Predefined report structure class

Parameters

Parameters