Setup Jaspersoft Studio for SQL

Download Jaspersoft Studio version 6.2.1

• Follow this link to the Jaspersoft Studio download page.

• Download version 6.2.1 (either the Windows or Mac version)

  • It's important to use the correct version of JasperSoft Studio for two reasons:

    1. Your version of JasperSoft studio needs to match the version on our servers.

    2. Version 6.2.1 is the most stable/bug-free version of Jaspersoft Studio at this time. Dealing with the bugs in the more recent versions will make it more difficult for you to learn how to use JasperSoft Studio.

  • We will make an announcement and update our documentation when it's time to upgrade to a more recent version.

What is Jaspersoft Studio?

Jaspersoft Studio is a free, open source, eclipse-based report designer for JasperReports and JasperReports Server. Users can create very sophisticated layouts containing charts, images, subreports, crosstabs and much more.

For this method, a direct database connection will be made to query the Illuminate postgres database to pull the data necessary for the prebuilt report being created.

Note that this is intended for district administrators that will have access to all data for the district.

Step 1: Connect to the Illuminate Database via Jaspersoft Studio

1. Open Jaspersoft Studio and locate the Repository Explorer.

2. Right click 'Data Adapters' and click 'Create Data Adapter.'

3. Select 'Database JDBC Connection' and click 'Next.'

4. For Name enter "Illuminate"

5. For JDBC Driver select 'PostgreSQL'

6. For JDBC URL enter: jdbc:postgresql://YOURHOSTIPADDRESS:5432/YOURDBNAME?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory

(Replace 'YOURHOSTIPADDRESS' with the IP address provided by Illuminate that you use in the host field when accessing the backend database and replace "YOURDBNAME" with the database name provided by Illuminate.)

Step 2: Connect to the Illuminate Jasper Server via Jaspersoft Studio 1. In the repository Exporer, right click on 'Servers' and 'Create JasperReports Server Connection.'

1. For Name enter "Illuminate Jasper"

2. For the URL enter: https://jasper.illuminateEd.com/jasperserver-pro/services/repository

3. For Organization enter your username

4. For Password enter the same one provided by Illuminate.
5. Click 'Finish.'

6. Expand the arrow next to the Server connection you just made.

7. Open the folder 'Reports' which contains 'DistrictCreated' folder that contains all of the district made prebuilt reports you make. The Illuminate prebuilt report templates are stored in the Public folder.