Create a report with Report Designer
Start Report Designer. Go toThe Report Designer home page appears. .NoteIf 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: