Adding several query objects to the design surface creates the potential for a large number of fields being displayed (even a single table can have 50 or more fields) and the resulting clutter can make analysis of your data difficult. This view displays only selected fields from each query object in the current dataModule.

Change

The "Change" button opens the Custom View page, which in turn contains two list boxes. The listbox on the left displays all available fields from all queries in the dataModule. Click on the desired field and move it to the right listbox by using the right arrow button. Fields can be deselected, moved out of the right listbox, by using the left arrow button.

There are oftentimes more than one top-level query present (a query that is not the child of another query). When this occurs, use the "Query Controlling Navigation" drop-down to select which top-level query should be used when displaying results in a Report or a View. Set the view by clicking the "Submit" button.

Get Results as Report

The "Get Results as Report" button displays a report of the data from the current dataModule. You must first create a Custom View, as described above, and the resulting report will only show the selected fields. Field names are displayed as titles across the top of the report, and fields from the Controlling Navigation Query are displayed with a darker background than fields from child queries. All parent-child relationships are traversed by the report, with parent rows printed once and child rows printed below respectively.

Get Results as View

The "Get Results as View" button displays the a view of the date from the current dataModule. Parent rows are displayed along with each child row, not on their own line. This format also traverses all parent-child relationships, and report titles are displayed as they are in the report format.