Using the Report Templates

The following templates are reports that have been created (mostly by other Illuminate districts) that you can use: 1. To learn from the reports. 2. As a jumping off point for your own reports.

Most reports will contain data that you may not have in your Illuminate site (i.e local assessments, etc.) These report templates will need to be modified in order to work for you.

Fields / Columns

In order to use these report templates, you must keep in mind the following key concept:

• The fields in the Jasper report must match the names of the columns in your custom report exactly.

There are two ways to accomplish this:

• Change the names of the fields in the Jasper report.

• Change the names of the columns in your custom report.

Fonts

In order for most of the templates to display properly, you will need to install the Illuminate font set and Font Awesome. (Please refer to this section of the eBook for information about how to install the fonts in JasperSoft Studio.)

Directions

To use the templates, follow the steps below: 1. Download the report template (a .jrxml file) from the BI Tool eBook and open the report in JasperSoft Studio. 1. Create a custom report in Illuminate with the same or similar fields (aka “columns” in a custom report). Remember, the names of the columns in your custom report must match the field names in the Jasper Report. 2. Download the data as a tab delimited .txt file. 3. Create a data adapter for your data. (Please refer to this section of the eBook for directions on creating data adapters.) 4. Open the jrxml in JasperSoft studio. 5. Change the names of the fields in the template to match your custom report. Do this before you link the data adapter. 5. Link the data adapter to the report template.

If the columns in your custom report match the fields in the Jasper report exactly, you should now be able to Preview the report.

If not, you’ll need to change the names of the fields in the Jasper Report to match the columns in your custom report. Do this by selecting the field in your “Outline” and going to the “Properties” tab.