Dashboard Report Setup

A Dashboard report allows you select any charts you have created in your project and show them in one single Dashboard report page, with links back to the original reports. Using this feature, you can enable users of your system to quickly understand the key indicators of your system with the visually rich charts.

After loading the database, the database objects (tables, views, Custom Views and reports) will be shown in the left pane (the database pane). To create a report, right click the database pane and select [Add Report (Dashboard)]. Alternatively, you can click [Edit] in the main menu and then select [Add Report (Dashboard)].

The Dashboard Report Setup window will show up:

 

General
Name Name of the report
Type

Type of the report. Possible values are:

  • Vertical - Charts are displayed vertically
  • Horizontal - Charts are displayed horizontally
  • Custom - Charts are displayed with your own Custom Template (see below)
Charts
Chart <n> Charts (from other reports) to be included in the Dashboard report
Width (px) Width of the chart (pixels) in the Dashboard report
Height (px) Height of the chart (pixels) in the Dashboard report

 

Press [OK] to finish setup. The Dashboard will appear under [Reports] in the Database pane on the left.

To edit a Report, right click the Report in the database pane and select [Edit Report]. Alternatively, you can select the Report first, then click [Edit] in the main menu and then select [Edit Report].

If you have selected Custom as the report type, you must provide a Custom Template. Select the dashboard report in the Database pane, you'll see the Code (Server Events, Client Scripts and Templates) tab on the right.

Select Custom Template > Table-Specific > Dashboard -> CustomTemplate and enter your HTML as the template of the Dashboard report page.

Custom Template is HTML in Razor code, if you want to embed server side code, you need to use @ character, if you want to use JavaScript, you need to use <script type="text/javascript"> and </script>.

Use {{{chart<n>}}} to denote a selected chart in your dashboard report. Note that <n> is an integer, e.g. chart1, chart2, chart3, etc. and there is no spaces between "chart" and "<n>". For example,

<table>
<tr><td>{{{chart1}}}</td><td>{{{chart2}}}</td></tr>
<tr><td colspan="2">{{{chart3}}}</td></tr>
</table>

During script generation, {{{chart<n>}}} will be replaced by the actual chart content you specify in the Charts setting.

 

Important Notes
  1. The dashboard report requires the source reports' *info.cs and *chart.cshtml scripts, when you generate or re-generate dashboard reports, make sure you have selected those scripts.
  2. After a report is created, if you rename or delete a source chart, the report will fail. Make sure you updated the report settings after renaming or deleting a source chart.
  3. Report supports User ID and User Level. (See Security)

 

 

Also see:

Tutorial - Dashboard Report

 

 ©2007-2017 e.World Technology Ltd. All rights reserved.