Highly Parameterized Chart and Table

micajblock

This example is based on a customer requirement and uses Classic Models as a database. The requirements were:

<br />
1. The field used as a measure was a parameter<br />
2. The date field used for the time series was a paramter<br />
3. The grouping of that date field (years, quarters, months) was a parameter<br />
4. Date range<br />
5. Optionally show the table<br />

<br />
There are two examples one used a cross-tab as the tabular format (Report1) and the other uses a regular table (Report2).<br />
<br />
The main trick was to dynamically change the query without changing the bindings (see beforeOpen event).<br />
<br />
Changing the the chart grouping dynamically was fairly easy (one you knew where to look).