If the report includes both a chart and a table, place the chart over the table on the report. The reason for this is, if the table spans multiple pages when printed and if the chart is below the table on the report, the table will print over the chart so that you cannot see the chart.
About this task
Important:
Do not position text and fields over the table because the table will be displayed over the text/field, and the text/field will not be visible.
Procedure
Select Table from the Insert menu.
A Table Assistant window is displayed.
From the Queries drop-down list, select the query from which you want to take data for the table.
Note:
Any created queries that still include errors are unavailable.
The Available Data box populates with the data that was previously defined for the query.
Use Add, Add all, Remove, and Remove All to add items from the Available Data box to the Data on Table box and remove items.
Use Move Up and Move Down to place the data items shown in the Data on Table box in the order you want them to be displayed on the table.
Items that are added to the Data on Table box are shown in the table you want to create.
Select Next.
The Table Assistant window is displayed.
Note:
You can change any of the options you select in Steps 5 through 10 after you have inserted the table with Format | Table.
Select either Horizontal or Vertical to define the orientation of the table.
Add a Summary line to the table by doing one of the following tasks:
If …
Then …
You want to place the Totals line at the top of the table as standard CMS reports do
Select Top.
You want to place the Totals line at the bottom of the table
Select Bottom.
You do not want to include a Totals line on this table
Select None.
Select the Headers On check box if you want to include column headers on the table.
Select the Grid Lines On check box if you want the table to include lines between the columns and rows.
Choose one of the following:
If …
Then …
You elected not to include a Summary line on the table
Select Done.
The Table Assistant is closed and the table is placed on the report template.
You elected to include a Summary line on the table
Select Next and go to the next step.
A Table Assistant window is displayed.
Choose one of the following:
If you want to …
Then …
Create a new query for the summary line on this table
