Collapses all nodes and drills up (starting from v2.1) all levels of all hierarchies in the slice on the grid and on charts.\n
All expanded/drilled down nodes will be collapsed/drilled up on the grid and on charts.
Returns an array of objects defining the sorting on the flat grid.
Note that the getFlatSort method is available only for reports based on "csv", "json", and "api" data source types.
Opens the calculated value pop-up window editor. Calling openCalculatedValueEditor results in opening an empty editor for creating a new value.
It is also possible to open this editor for editing or deleting an existing calculated value.
Note that this API call has no callbackHandler parameter in Flutter.
This API call allows you to control redrawing of the component when you use the following API calls:
addCondition(), removeAllConditions(), removeCondition(), setFormat(), setOptions()
Removes all calculated measures.
Note that the removeAllCalculatedMeasures method is available only for reports based on "csv", "json", and "api" data source types.
Removes the calculated measure by the measure’s unique name.
Note that the removeCalculatedMeasure method is available only for reports based on "json", "csv", and "api" data source types.
Runs a query with specified rows, columns, measures and reportFilters from the SliceObject and displays the result data.
Use this method to rearrange hierarchies on the axes or to compose a new report based on the current data source.
Sets a default number format or the number format for the specified measure.
To apply a default format to all measures, leave the measureName and aggregation parameters undefined.
To apply a format only to a specific measure, specify the measureName and aggregation parameters. Learn more in this guide: Number formatting.
Use refresh() API call after setting a format to redraw the component and see changes.
Sets table sizes for the component. Use this method to set table sizes without updating the report.
When called, the setTableSizes() method overwrites previously set table sizes.
Saves the current report to Flexmonster Data Server and provides a link to the saved report.
To save a report, Flexmonster creates an XMLHttpRequest and sends it to the Data Server as a POST request. The request is sent to <url>/save, where url is the Data Server’s URL (e.g., http://localhost:9500).
For more details on report sharing, see this guide: Share the report.
Switches to the charts view and shows the chart of the specified type.
The following chart types are supported: "column", "bar_h", "line", "scatter", "pie", "stacked_column" and "column_line".
After showCharts() API call options.viewType property in the report will be "charts".
Switches to the grid and charts view and shows the chart of the specified type.
The following chart types are supported: "column", "bar_h", "line", "scatter", "pie", "stacked_column" and "column_line".
After showCharts() API call options.viewType property in the report will be "grid_charts".
Helps to update data for the report without cleaning the report. Only the dataSource is updated, whereas the slice, all defined options, number and conditional formatting, the scroll position stay the same.
For all data sources, updateData allows connecting to a new data source. For a JSON data source, it is also possible to update only some part of the data.