Get Free Trial

How do i achieve toolbar options menu values

Bilguun asked on September 2, 2020

Hello flex team,
as i mentiond for title situation how to access options menu values mean
this, i tried but which one is right options i didnt know

2 answers

Vera Didenko Vera Didenko Flexmonster September 2, 2020

Hello, Bilguun,
Thank you for writing to us. 
These options can be set in the options object in your report configuration, for example: 

var pivot = new Flexmonster({
container: "#pivot-container",
componentFolder: "",
toolbar: true,

report: {
dataSource: {
type: "json",
data: getData()
options: {
grid: {
type: "compact",
showTotals: "on",
showGrandTotals: "on"

We have prepared a JSFiddle example for illustration:

Also, here is how to achieve each of the options provided in the “Options” Tab through the report configuration:

  • “Do not show subtotals” – showTotals: "off",
  • “Show subtotals” – showTotals: "on",
  • “Show subtotal rows only” – showTotals: "rows",
  • “Show subtotal columns only” – showTotals: "columns"
  • “Do not show grand totals” – showGrandTotals: "off"
  • “Show grand totals” – showGrandTotals: "on"
  • “Show for rows only” – showGrandTotals: "rows"
  • “Show for columns only” – showGrandTotals: "columns"
  • “Compact form” – type: "compact"
  • “Classic form” – type: "classic"
  • “Flat form” – type: "flat"

Please let us know if this helps. 
Looking forward to your reply.
Kind regards, 

Bilguun September 2, 2020

Thank you Vera

Please login or Register to Submit Answer