Navigating the Report Designer window

All report types, except for presentations and SQL reports, open the Report Designer window with the Tables tab selected. The Report Designer window is shown below.

 

   Figure 60: Report Designer Window

The Report Designer tabs are listed in the following table.

Table 31: Report Designer Tabs

Tab Name

Description

Table

Used to select the tables to include in your report query, as described in Selecting Tables on page 127.

Column

Used to select the columns to include in your report query, as described in Selecting Columns on page 129.

Join

Used to define the relationship between tables when using data from multiple tables in a report, as described in Creating Joins between Tables on page 134.

Condition

Used to define conditions that narrow the scope of the data that is returned from the database, as described in Creating Conditions on page 138.

Order By

Used to determine how the rows in a report are to be ordered, as described in Sorting Data on page 152. Not available for Cubes, Crosstabs and Presentations.

Procedures

Used to select and run existing stored procedures, as described in Using Stored Procedures on page 154. This tab is only available when enabled in the user configuration.

Report

Used to design the report data and layout, as described in Creating a Tabular Report on page 171.

Chart

Used to design the chart data and layout, as described in Creating a Chart on page 192.

LChart

Used to design the lightweight chart data and layout, as described in Creating a Lightweight Chart on page 211.

Cube

Used to design the cube data and layout, as described in Creating a Cube on page 231.

Crosstab

Used to design the crosstab data and layout, as described in Creating a Crosstab on page 224.

Presentation

Used to design presentations, as described in Creating a Presentation Layout on page 217.

SQL

Used to create tabular reports from SQL statements, as described in Using the SQL Tab on page 158.

Temp Table

Used to create temporary or derived tables to be used by other reports, as described in Using Temporary and Derived Tables on page 163.

You can use the left and right arrow buttons, shown below, to move between the tabs.

 

   Figure 61: Tab Change Buttons

The button bar at the top of the Report Designer window contains a fixed set of buttons. These can be used to quickly access the most common tasks or change the report type. The button name is displayed as a tool tip when the mouse cursor is placed over the button. You can also access each of these tasks from the menu bar at the top of the page.

The buttons are identified in the following figure.

 

   Figure 62: Report Designer Windows Buttons