Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

How do i achieve toolbar options menu values

Answered
Bilguun asked on September 2, 2020

Hello flex team,
as i mentiond for title situation how to access options menu values mean https://imgur.com/a/DyGzz0b
this, i tried but which one is right options i didnt know
 

2 answers

Public
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: "https://cdn.flexmonster.com/",
toolbar: true,

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

We have prepared a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/wyjdfto9/

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, 
Vera

Public
Bilguun September 2, 2020

Thank you Vera

Please login or Register to Submit Answer