Perform the steps below to create a report
using Report Designer:
-
Start Report Designer. Go to Start > Programs > Pentaho Enterprise Edition > Design Tools > Report Designer.
The Report Designer home page appears.Note: If you would like to change the size of the layout bands to give yourself more area to work in without changing the dimensions of the published report, you can click and drag the percentage number in the upper left corner of the workspace. The default is 100%, but if you click and drag it diagonally toward the upper left or lower right corners, the view will zoom in or out. If you want to reset the view to 100%, double-click the upper left corner where the percentage shows.
-
Click New
Report in the Welcome dialog box.
The design workspace appears.
- In the right pane, click the Data tab.
-
For the purpose of this exercise, right-click Data Sets
and choose JDBC. Alternatively, you can click the yellow
database icon to display the JDBC Data Source dialog box.
The JDBC Data Source dialog box appears.
- Under Connections, select SampleData (Hypersonic).
-
Next to Available Queries, click the Plus Sign to add
queries.
Query 1 appears under Available Queries and the edit (pencil) icon is now available, as shown below. -
Click the editing icon (
).
The SQL Query Designer window opens. The SQL Query Designer provides you with a graphical environment which allows you to work with the data even if you do not understand SQL, the standard programming language for retrieving content from databases. -
Select PUBLIC in the schema filter menu, and
then double-click ORDERFACT so that the table appears in
the workspace, as shown below.
-
In the SQL Query Designer workspace, right-click
ORDERFACT and choose deselect
all, as shown below.
-
Now, select the ORDERNUMBER,
QUANTITYORDERED, PRICEEACH,
and ORDERDATE fields in the
ORDERFACT table, as shown below.
-
Double-click PRODUCTS so that the table also appears in
the workspace.
Notice the line joining the ORDERFACT and PRODUCTS tables together.
-
Clear all the PRODUCTS table fields, and then select
just the PRODUCTNAME and
PRODUCTLINE fields, as shown below.
-
For the purpose of this exercise, click the Syntax tab
in the lower left portion of the SQL Query Designer
workspace to display a simple SQL statement associated with the tables.
Notice that PRODUCTCODE is the common field between the ORDERFACT and PRODUCTS tables, as highlighted below:
-
Click OK in the syntax window to return to the
JDBC Data Source dialog box.
The SQL statement appears on the right under Query.
-
Click OK in the JDBC Data
Source dialog box.
The fields associated with your tables are now under Query 1, as shown below:
You are now ready to start designing your
report.