Access the SQL Query Designer

Pentaho Report Designer

Part Number
Perform the following steps to access the SQL Query Designer:
  1. In the Data tab, right-click on Data Sets and select JDBC.
    The JDBC Data Source window appears.
  2. Select your data source in the Connections pane on the left, then click the round green + icon above the Available Queries pane on the right.
  3. Type a concise yet sufficiently descriptive name for your query in the Query Name field.
  4. Click the pencil icon above the upper right corner of the Query field.
    The SQL Query Designer tool appears, as shown in the following example:
    SQL Query Designer