Inserting a populated table

You can insert a table object that is populated with data from an existing query.

1. Double-click the Table object in the Layouts palette of the Palette view.
   The Table Wizard opens.
2. Select Yes and click Next.
   The Select the query page opens.
3. In the All Data Sources tree, navigate to the table or query that will be run to obtain the layout object's query result set and click Next.
4. Select one or more columns in the Available fields list box and click Move Right to move them to the Columns to be created list box.
   This field lists the names of the columns of data that are included in the selected query result set. The Specify table options page opens.
5. Select the Include title row check box to create a title row.
6. Select the Include header row check box to create a header row.
7. Select the Include footer row check box to create a footer row.
8. Select the Word-wrap cell text check box to make the text in each cell fit the cell space.
9. Specify the alignment of the text in the cells in the Alignment list.
   The valid options are:

   • Left
   • Right
   • Center
10. Specify the minimum width of each cell in the Minimum width field.
11. Specify the height limit of the table in the Height Limit field. Zero (0) value means that the table height is unlimited. Any value different from zero (0) sets the maximum table height.
12. Select the necessary Scroll Scope value from the list:
    • Entire Table to scroll the whole table.
    • Data Only to scroll only table data.
    • Data and Heading to scroll only table data and column headers.
13. Select the necessary value from Vertical Scroll list to set the vertical scrolling.
14. Specify the width limit of the table in the Width Limit field. Zero (0) value means that the table width is unlimited. Any value different from zero (0) sets the maximum table width.
15. Click Next.
    The Specify paging options page opens.
16. Select the Enable paging check box to enable paging.
    Paging allows you to display only a certain amount of rows at a time.
17. Specify the amount of rows that you want to display at a time in the Rows per page list.
18. Select the first row in the result set to display in the First displayed row list.
19. Select the Add navigation bar check box to automatically create page forward and page backwards buttons that control paging actions.
20. Click Finish.
    The wizard closes and the table is displayed in the editor window.