Menu
Download Free Trial
  1. API reference
    1. $.flexmonster
  2. Objects
    1. Report Object
    2. Slice Object
    3. Options Object
    4. Format Object
    5. Conditional Format Object
    6. Cell Object
  3. Methods
    1. addCalculatedMeasure
    2. addCondition
    3. addJSON
    4. clear
    5. clearFilter
    6. clearXMLACache
    7. closeFieldsList
    8. collapseAllData
    9. collapseData
    10. connectTo
    11. customizeCell
    12. dispose
    13. expandAllData
    14. expandData
    15. exportTo
    16. fullScreen
    17. getAllConditions
    18. getAllHierarchies
    19. getAllMeasures
    20. getCell
    21. getColumns
    22. getCondition
    23. getData
    24. getFilter
    25. getFilterProperties
    26. getFormat
    27. getMeasures
    28. getMembers
    29. getOptions
    30. getPages
    31. getReport
    32. getRows
    33. getSelectedCell
    34. getSort
    35. getXMLACatalogs
    36. getXMLACubes
    37. getXMLADataSources
    38. getXMLAProviderName
    39. load
    40. off
    41. on
    42. open
    43. openFieldsList
    44. print
    45. refresh
    46. removeAllCalculatedMeasures
    47. removeAllConditions
    48. removeCalculatedMeasure
    49. removeCondition
    50. removeSelection
    51. runQuery
    52. save
    53. setBottomX
    54. setFilter
    55. setFormat
    56. setOptions
    57. setReport
    58. setSort
    59. setTopX
    60. showCharts
    61. showGrid
    62. showGridAndCharts
    63. sortValues
    64. updateData
  4. Events
    1. beforetoolbarcreated
    2. cellclick
    3. celldoubleclick
    4. datachanged
    5. dataerror
    6. datafilecancelled
    7. dataloaded
    8. exportcomplete
    9. exportstart
    10. fieldslistclose
    11. fieldslistopen
    12. filteropen
    13. loadingdata
    14. loadinglocalization
    15. loadingolapstructure
    16. loadingreportfile
    17. localizationerror
    18. localizationloaded
    19. olapstructureerror
    20. olapstructureloaded
    21. openingreportfile
    22. printcomplete
    23. printstart
    24. querycomplete
    25. queryerror
    26. ready
    27. reportchange
    28. reportcomplete
    29. reportfilecancelled
    30. reportfileerror
    31. runningquery
    32. update
Table of contents

Events

Flexmonster Pivot Table & Charts Component offers plenty of events. Try on() and off() functions to handle any event.

List of events:

reportcomplete triggered when the operations can be performed with the component (data source file or OLAP structure was loaded successfully and the grid/chart was rendered)
beforetoolbarcreated triggered before the creation of Toolbar
cellclick triggered when a cell is clicked on the grid
celldoubleclick triggered when a cell is double clicked on the grid
datachanged triggered after the user edits data
dataerror triggered when some error occurred during the loading of data
datafilecancelled triggered when Open file dialog was opened and customer clicks Cancel button
dataloaded triggered when the component loaded data
exportcomplete triggered after the export file was generated successfully
exportstart triggered when the export of grid or chart starts
fieldslistclose triggered when the built-in Fields List is closed
fieldslistopen triggered when the built-in Fields List is opened
filteropen triggered when a filter icon is pressed
loadingdata triggered when data starts loading from from local or remote CSV, JSON or after report was loaded
loadinglocalization triggered when localization file starts loading
loadingolapstructure triggered when structure of OLAP cube starts loading
loadingreportfile triggered when a report file started loading
localizationerror triggered when some error appeared while loading localization file
localizationloaded triggered when localization file was loaded
olapstructureerror triggered when some error appeared while loading OLAP structure
olapstructureloaded triggered when OLAP structure was loaded
openingreportfile triggered when customer uses menu Open -> Local report or API method open() is called
printcomplete triggered after OS print manager was closed
printstart triggered when print(options:Object) method was called or Export > Print was selected in the Toolbar
querycomplete triggered after the data query was complete
queryerror triggered if some error occurred while running the query
ready triggered when the component’s initial configuration completed and the component is ready to receive API calls
reportchange triggered when a report is changed in the component
reportfilecancelled triggered when customer uses menu Open -> Local report and clicks Cancel button
reportfileerror triggered when some error occurred during the loading of the report file
runningquery triggered before data query is started
update triggered when the change occurred in the component