To access report Settings dialogue window, hover your mouse over button Edit and select option Settings.

Report settings dialogue window allows you to:

  • set Refresh interval on data change
  • set Calculations results validity
  • set Report View timeout interval
  • set Sidebar width
  • set Adaptive layout

Refresh interval on data change parameter serves to set how often will be changed in the source data set checked. When change in source data is detected, report is automatically refreshed. Default value is set to 2 seconds.

Calculations result validity parameter is dedicated to speedup reports re-loading time. However data are being calculated in-memory and some of them are already cached on database subsystem layer, there is quite huge CPU overhead while computing formula.

Report View timeout interval parameter sets time in second until formula calculations are terminated. If formulas in views are not calculated in specified time, view will not be displayed. This can be used to not block other users during high load on servers.

Adaptive layout will switch to different layout style. View are not automatically aligned. Each view can have a unique size. Usually, adaptive layout handles better mobile devices and views are aligned below each other. In adaptive layout report is split to 100 columns, where user can set view. Those 100 columns are only part of report layout, not whole vertical resolution (scroll bar, side menu and others must be deducted from whole horizontal resolution). For full screen google chrome on Full HD Windows this number is around 1853px. So one step would be 18.5px.

Layout view height - If adaptive layout is on, you can set behavior of Layout height. One step for height for height adjustment is taken from one step of width. So in this scenario it would also be 18.5px.

  • Auto - Aspect ration of view will stay the same after browser window size change. Height value will change by steps defined by one width step. Default settings.
  • Fixed - Height of view will stay the same after browser window size change.
  • 10 pixels - Height can be set by 10 pixels.


Sidebar width. When Adaptive layout is active and the width is set, the report will split into two parts. The right-hand section can be retracted from the screen using a single button. This is useful because unimportant information can be displayed or hidden as needed.

HTML content inserted after report content - Can provide easy solution, how to add any javascript to report page. This content is then generated at the end of reprort.


There are several reasons why it is not used automatically everytime - each formula might contain some parameters evaluated in runtime (cross values, date/time modifiers etc), so we cannot cache just by the formula context (date/time/drilldown/filter) and formula definition itself. On the other hand, formula calculation cache automatically expires after desired period of time [s] or on the data or context change. Default value is set to 60 seconds.
  • No labels