Flexmonster chart is unscrollable when pivoting against many ROWS

Hello, Jun Jie,

Thank you for reaching out to us.

This behavior is caused by the autoSwitchToCompact: false option in your report configuration. The classic form is designed with a frozen area for row members and a scrollable area for values, so you can always see which members you are analyzing. When many row fields are expanded, the frozen area grows with them, since each hierarchy level is shown in a separate column. By default, Flexmonster prevents it from taking up the full width by automatically switching to the compact form. With autoSwitchToCompact set to false, this switch is disabled, so the frozen area can occupy all available space, leaving no room for the values.

To resolve this or minimize the effects, you can choose one of the following approaches:

1. Remove autoSwitchToCompact: false from options.grid (or set it to true). Flexmonster will then switch to the compact form when the classic layout no longer fits.
2. Reduce the width of the row header columns so the rows area takes less space. Users can resize the columns directly in the grid by dragging the header borders, or you can predefine the widths in the report using the tableSizes object.
3. Give the grid more space by switching to full-screen mode via the Fullscreen button in the Toolbar or by increasing the width of the component's container.

Please let us know if one of these approaches works for you.

Best regards,
Maksym