Demo
Documentation
Forum
Blog
Search
DOWNLOAD
Demo
Documentation
Forum
Blog
Download
Documentation menu
Getting started
Intro
Download
Quick start
Need more features?
Integration with frameworks
Available tutorials
Integration with Angular
Integration with React
Integration with Vue
Integration with Python
Integration with Django
Integration with Jupyter
Integration with Flutter
Integration with jQuery
Integration with AngularJS
Data sources
JSON
Supported JSON formats
Setting data types in JSON
Connecting to JSON
Creating multilevel hierarchies
Mapping object for JSON
CSV
Supported CSV format
Setting data types in CSV
Connecting to CSV
Data type prefixes
Configuring fields
Field List
Calculated values
Drag and drop
Pivoting functionality
Expand and collapse
Drill up and down
Filtering
Sorting
Aggregation functions
Drill through
Formatting
Number formatting
Conditional formatting
Grid layout
Grid forms
Grand totals and subtotals
Column and row resizing
Saving and loading reports
Loading the report
Saving the report
Exporting and printing
Add-ons
The Toolbar
Customizing
Language localization
Changing component themes
Custom component themes
Customizing the Toolbar
Integration with charts
Available tutorials
Integration with amCharts
Integration with Highcharts
Integration with FusionCharts
Integration with Google Charts
Technical specifications and licensing
Browser compatibility
Technical specifications
License agreement
WebDataRocks dependencies
API Reference
Introduction
Init API call
Objects
Cell Data Object
Conditional Format Object
Data Source Object
Format Object
Global Object
Options Object
Report Object
Slice Object
Methods
Chart connectors
All connectors
amcharts.getCategoryName
amcharts.getData
amcharts.getMeasureNameByIndex
amcharts.getNumberFormatPattern
amcharts.getNumberOfMeasures
fusioncharts.getData
googlecharts.getData
highcharts.getData
collapseAllData
customizeCell
expandAllData
exportTo
getAllConditions
getAllHierarchies
getAllMeasures
getData
getOptions
getReport
getCell
getSelectedCell
load
off
on
refresh
removeSelection
runQuery
save
setOptions
setReport
updateData
Events
beforetoolbarcreated
cellclick
celldoubleclick
dataloaded
reportchange
reportcomplete
update
Sorting
To see the most
relevant information first
, apply
sorting
to the values on the grid.
To sort the data right on the grid
Hover over the name of the column/row.
To sort the records in the rows/columns
descending
, click the sorting control near the hierarchy caption.
Click again to sort
ascending
.
To remove sorting from the data on the grid
Right-click the member name and cancel sorting via the context menu.