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 |