Create a Basic Report with SQL
Last updated
Was this helpful?
Last updated
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.
Please click the links below and push the "Download" button:
The following steps guide you to create a new jrxml file:
Open the blank template you downloaded above in Jaspersoft Studio.
Note: The file extension is jrxml for the report files.
Click File > Save As to create a copy of the template.
Name your report.
Select the Data Adapter you want to use for the report. Be sure to use the PostgreSQL Connection.
On the top right of the report page, click the 'DataSet & Query editor dialogue' button.
Enter the query you want to use to populate your report. For example:
Click 'Read Fields' and the column names from the custom report should appear below.
Click 'OK.'
You should now have a blank report to drag elements from the query onto the page.
The following Jaspersoft tutorial walks through creating a basic report:
The following Jaspersoft tutorial explains the stucture of a Jasper Report:
Creating Expressions:
Using Variables:
Creating Report Groups:
