Creating a New Report
To create a new report
|
1.
|
Go to File > New > Jasper Report or click on the main toolbar. |
The New Report Wizard window displays the Report Templates page. Jaspersoft Studio includes a number of pre-installed templates; you can also create your own. See Report Templates for more information.
|
Figure 7: New Report Wizard
|
|
2.
|
Select the Coffee template and click Next. The New Report Wizard shows the Report file page. |
|
Figure 8: New Report Wizard > Report file
|
|
3.
|
Navigate to the folder to which you want the save report and name the report. To create a folder, see Creating a Project Folder. |
The New Report Wizard displays the Data Source page. This is where you choose the data that fills the report. The dropdown menu shows the pre-installed data adapters as well any data adapters you have added. The following adapters are pre-installed:
|
•
|
One Empty Record - Empty rows: Data adapter that lets you create a report without data. You might use this option to define the layout of a report and connect it to a data source later. |
|
•
|
Sample DB - Database JDBC Connection: Data adapter that connects to an SQL database provided with the Jaspersoft Studio installation. If you are getting your data from a JDBC database, you must also supply an SQL query. |
|
You can create a data adapter separately or click New... to create a data adapter directly from this dialog. Adapters can be created globally (embedded in the workspace) or local to a specific project. Using a local adapter makes it easier to deploy the report to JasperReports Server. See Creating and Editing Data Adapters for more information.
|
|
5.
|
Choose Sample DB - Database JDBC Connection. With a JDBC connection, the Data Source dialog shows the database schema on the left and your query on the right. |
|
Figure 9: New Report Wizard > Data Source
|
|
6.
|
Enter the query SELECT * FROM ORDERS on the right. Note that you can view your query in three different ways: as text, as an outline, or as a diagram. |
|
7.
|
Click Next. The Fields window is displayed. The Dataset list shows all the discovered fields. |
|
Figure 10: New Report Wizard > Fields
|
|
8.
|
Select the following fields and click the right arrow to add them to your report. |
|
9.
|
Click Next. The Grouping window is displayed. You do not want any grouping for this report. |
|
10.
|
Click Next and Finish. |
Jaspersoft Studio now builds the report layout with the selected fields included as shown.
|
Figure 11: New Report in the Design Tab
|
Recommended Comments
There are no comments to display.