Create a Basic Report with SQL

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.

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:

1. Open the blank template you downloaded above in Jaspersoft Studio.

   • Note: The file extension is jrxml for the report files.

2. Click File > Save As to create a copy of the template.

3. Name your report.

4. Select the Data Adapter you want to use for the report. Be sure to use the PostgreSQL Connection.

5. On the top right of the report page, click the 'DataSet & Query editor dialogue' button.
6. Enter the query you want to use to populate your report. For example:

   SELECT "site_id", "site_name", "address", "phone1", "principal_name", "zip"
   FROM "public"."sites"
   ORDER BY site_name

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

8. Click 'OK.'

9. You should now have a blank report to drag elements from the query onto the page.

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

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

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

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

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