Illuminate BI Tool Guide
  • Introduction
  • Example BI Reports
  • What is BI Reporting in Illuminate?
  • Getting Started Using BI with Custom Reports
    • Setup Jaspersoft Studio
    • Prepare Your Data Set
    • Create a Basic Jasper Report
    • Publish My Report to Illuminate
    • Edit Report After Publishing
    • Display Selected Filters on Your Report
  • Get Started Using BI with SQL
    • Access Data Via ODBC Connection
    • Learn the Schema
    • Setup Jaspersoft Studio for SQL
    • Create a Basic Report with SQL
    • Publish My Report (SQL Method)
    • Adding Input Controls
  • Tutorials
    • Tutorials for Free Version ("Community Edition")
      • Tutorial 1: Categorize and Aggregate Your Data
      • Tutorial 2: Using Jasper Report Bands
      • Tutorial 3: Student Roster Report
      • Tutorial 4: Student Roster with SQL
      • Tutorial 5: Summary of Performance
      • Tutorial 6: CELDT Longitudinal Summary
    • Tutorials for Pro Version ("Professional Edition")
      • Tutorial 1: Aggregate and Visualize Your Data
        • Step 1 - Create a Custom Report
        • Step 2 - Download Your Data
        • Step 3 - Create a Data Adapter
        • Step 4 - Duplicate Template. Link Data Adapter
        • Step 5 - Set Class for Numeric Fields
        • Step 6 - Add & Configure Chart
        • Step 7 - Resize Chart. Preview Report.
        • Step 8 - Change Chart Labels
        • Step 9 - Set Chart Colors
        • Step 10 - Repeat for Other Data Points
        • Step 11- Install Your Report
      • Tutorial 2: Using Report Bands
        • Step 1 - Duplicate Report from Tutorial 1
        • Step 2: Create Your Group
        • Step 3: Create a Sort Field
        • Step 4 - Copy & Paste Your Chart
        • Step 5 - Set Reset Type and Evaluation Time
        • Step 6 - Change the Category Level
        • Step 7 - Add Site Name Field
        • Step 8 - Grade Level Sorting
    • CrossTabs Tutorial - Create, Format, and Style a CrossTab
      • Step 1 - Create Your CrossTab
      • Step 2 - Size and Position Your CrossTab
      • Step 3 - Format and Style Your CrossTab
  • Homework 1 - BI Workshop Follow Up
  • BI Tool Cheat Sheet
  • JasperSoft Studio Tips, Tricks, & FAQs
    • Basics of Writing Expressions in JSS
    • Rounding Decimals
    • Working with Dates in JSS
    • Conditional Styling in JasperSoft
    • Custom "No Data" Message
    • Create Multiple Summary Bands
    • Create Hyperlinks or "Tabs" to Connect Sets of Reports
    • JSS Community Edition
      • Adding Data Labels to Your Chart
      • Customizing Colors in Your Charts
    • JSS Professional Edition Only
      • HTML5 Charts
        • Data Labels: Enable, Customize, & Round Data Labels
        • Tooltip: Customizing the Tooltip
        • Keeping Colors Consistent in HTML5 Charts
        • Adding Drill Down to a Chart
        • Prevent Tooltip from Being Cut Off
        • Sort the Bars in Your Stack - Ordering the Series in Your Chart
        • Passing Parameters/Data Between Datasets with HTML5 Charts
        • Add Plot Lines to your Chart
        • Add Colored Zones or Plot Bands to Your Chart
        • Change Bar Colors Based on Bar Value
    • Rolling Over Your BI Tool Reports
    • "Current" Columns in Custom Reporting - To Use or Not to Use?
  • Report Design Best Practices
  • Installing the Illuminate Font Set
  • Report Templates
    • Blank Templates - Report Starters
    • Using the Report Templates
    • Multiple Measures Site Comparison Report (Tutorial 5)
    • EL Reclassification Report
    • EL Reclassification Report v2
    • RFEP Monitoring Report
    • Student Rubric Template
    • Michigan Report Templates
      • PSAT and SAT College Readiness Report
  • BI Tool User Community
Powered by GitBook
On this page
  • Fields / Columns
  • Fonts
  • Directions

Was this helpful?

  1. Report Templates

Using the Report Templates

PreviousBlank Templates - Report StartersNextMultiple Measures Site Comparison Report (Tutorial 5)

Last updated 5 years ago

Was this helpful?

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. () 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.

Please refer to this section of the eBook for directions on creating data adapters.