Create a Basic Jasper Report

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."

1. On the top right of the report page, click the 'DataSet & Query editor dialogue' button.
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).

   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

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