# Create a report with Report Designer

Perform the steps below to create a report using Report Designer:

1. 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.
2. Click **New Report** in the Welcome dialog box.

   The design workspace appears.
3. In the right pane, click the **Data** tab.
4. 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.
5. Under **Connections**, select **SampleData (Hypersonic)**.
6. Next to **Available Queries**, click the Plus Sign to add queries.

   ![JDBC Data Source dialog box](/files/WzOkOaNeLtOEcQVs5n8a)

   Query 1 appears under **Available Queries** and the edit (pencil) icon is now available, as shown below.
7. Click the editing icon (![Edit](/files/pV0eWN9Co7HdpLZrenR2)).

   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.
8. Select **PUBLIC** in the **schema filter** menu, and then double-click **ORDERFACT** so that the table appears in the workspace, as shown below.

   ![SQL Query Designer](/files/y2t1vuLb1ipqJT077GeS)
9. In the SQL Query Designer workspace, right-click **ORDERFACT** and choose **deselect all**, as shown below.

   ![Clear all, SQL Query Designer](/files/Dmaqvii6qbNFk1gAfm84)
10. Now, select the **ORDERNUMBER**, **QUANTITYORDERED**, **PRICEEACH**, and **ORDERDATE** fields in the **ORDERFACT** table, as shown below.

    ![Orderfact fields](/files/vEvUiOBZ58fYU2ieXt9h)
11. Double-click **PRODUCTS** so that the table also appears in the workspace.

    Notice the line joining the **ORDERFACT** and **PRODUCTS** tables together.
12. Clear all the **PRODUCTS** table fields, and then select just the **PRODUCTNAME** and **PRODUCTLINE** fields, as shown below.

    ![Products table](/files/QxKqcDRW5oJh5vO1E2TI)
13. 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:

    ![Syntax tab](/files/DShbQcw6nT2yObCHtqVm)
14. Click **OK** in the syntax window to return to the JDBC Data Source dialog box.

    The SQL statement appears on the right under **Query**.
15. Click **OK** in the JDBC Data Source dialog box.

    ![Query 1 fields](/files/h8ho9Fy8XPFSjQPQaReW)

    The fields associated with your tables are now under **Query 1**, as shown below:

You are now ready to start [designing your report](/pdia-try-pdia/archive-flattened-pages/report-designer-merged-pages/design-your-report.md).


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pentaho.com/pdia-try-pdia/archive-flattened-pages/report-designer-merged-pages/create-a-report-with-report-designer.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.