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

Was this helpful?

  1. Getting Started Using BI with Custom Reports

Create a Basic Jasper Report

PreviousPrepare Your Data SetNextPublish My Report to Illuminate

Last updated 5 years ago

Was this helpful?

IMPORTANT: We highly recommend that all BI Tool users use Illuminate's Blank Templates/Report Starters to start your report. The templates/report starters contain dozens pre-built parameters and variables that will make it easier for you to start your report.

If you are using our blank templates/report starters, you can skip steps 1 and 2 below. Those steps are already done for you.

Please click the links below and push the "Download" button:

  • Blank Template - Landscape

  • Blank Template - Portrait

The following steps guide you to create a new jrxml file. For more detailed directions, please refer to the "Tutorials" in this guide:

  1. Open Jaspersoft Studio and click File > New > Jasper Report, select "Blank Letter," and name the report. Note: The file extension is .jrxml for the report files.

  2. Create a new parameter named ILLUMINATE. Find the widget that shows "Outline," right click on "Parameters," select "Create Parameter," change the "Name" called ILLUMINATE. Uncheck "Is For Prompting."

  2. In the section Query Language, type in the following: illuminate_custom

  3. Select the Data Adapter you want to use for the report.

  4. Click 'Read Fields' and the column names from the custom report should appear below.

  5. Click 'OK.'

  6. Note that all fields initially imported as type "string," which means they are text. Best practice would be to change all numeric fields to either integer or double (decimal values).

Here are some of the most commonly used options for the Class:

    java.lang.Integer 
    java.math.BigDecimal 
    java.util.Date 
    java.lang.Boolean 
    java.lang.String 
    java.lang.Double

  1. You should now have a blank report to drag elements onto the page.

  2. The following Jaspersoft tutorial walks through creating a basic report: https://community.jaspersoft.com/wiki/designing-report-jaspersoft-studio

  3. The following Jaspersoft tutorial explains the stucture of a Jasper Report: https://community.jaspersoft.com/wiki/report-structure-jaspersoft-studio

  4. Creating Expressions: https://community.jaspersoft.com/wiki/jaspersoft-studio-expression-editor-what-it-and-how-it-works-part-1

  5. Using Variables: https://community.jaspersoft.com/wiki/variables

  6. Creating Report Groups: https://community.jaspersoft.com/wiki/groups

  7. Jasper Studio User Guide: http://community.jaspersoft.com/documentation/v56-v561-v560/jaspersoft-studio-user-guide

On the top right of the report page, click the 'DataSet & Query editor dialogue' button.

Click the field and find the properties window. For integer fields change the "Class" to java.lang.Integer, for decimal values use java.lang.Double