Wednesday, 3 October 2012

NextReports: Widgets with dynamic parameters

NextReports widgets (charts, tables, alarms, pivots) can show you important and live data inside dashboards. The entities behind (charts or reports) can have or not parameters. You can have for example a chart showing exchange rates for the last two weeks without using date parameters (like the one found on the demo server).  The query used to perform this using MySql is:

If you want to have parameters, to tweak them for server UI, you must define them with a default source inside designer definition. You can define start date for example to be with 7 days previous to current date like:

End date parameter will be just the current date:

NextReports is able to schedule a report with such parameters using a dynamic check flag. By selecting it, the server assumes that the values for those parameters will be computed at run time instead of using the computed stored (static) default values.

For widgets there was not possible to have dynamic values for parameters. With the forthcoming 5.4 version it will be possible to select dynamic flags for widget settings like in scheduler definition:

In this way you can play with same widget both in seeing data for a dynamic period of time and in analyzing data for a specific static period of time.