Inserting a table

Last Updated : Apr 30, 2015 |
Prolog information
Metadata
Keywords:
Resource Id: Inserting_a_table_on_the_report:78
Resource Id: RD_GDES_QUERY:79
Resource Id: RD_GDES_SUMMARY:81
Resource Id: RD_GDES_LAYOUT:80
Before you begin
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.
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.
  1. Select Table from the Insert menu.
    STEP RESULT:
    A Table Assistant window is displayed.
  2. From the Queries drop-down list, select the query from which you want to take data for the table.
    ADDITIONAL INFORMATION:
    Note:
    Any created queries that still include errors are unavailable.
    STEP RESULT:
    The Available Data box populates with the data that was previously defined for the query.
  3. 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.
    ADDITIONAL INFORMATION:
    • 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.
  4. Select Next.
    ADDITIONAL INFORMATION:
    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.
  5. Select either Horizontal or Vertical to define the orientation of the table.
  6. Add a Summary line to the table by doing one of the following tasks:
    ADDITIONAL INFORMATION:
    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.
  7. Select the Headers On check box if you want to include column headers on the table.
  8. Select the Grid Lines On check box if you want the table to include lines between the columns and rows.
  9. Choose one of the following:
    ADDITIONAL INFORMATION:
    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.
  10. Choose one of the following:
    ADDITIONAL INFORMATION:
    If you want to …
    Then …
    Create a new query for the summary line on this table
    Go to Step 11.
    Use an existing query for the summary line on this table
    Go to Step 15.
  11. Select Build a New Query.
  12. Enter a name for the summary query in the Name field.
  13. Edit the table to include the database items and summary information that is appropriate for this summary query.
  14. Go to Step 17.
  15. Select Select an Existing Query.
    STEP RESULT:
    A Table Assistant window is displayed.
  16. Select the name of one of the existing queries from the drop-down Queries list.
  17. Select Done.