Auto reports are an easy and efficient way of creating reports. When browsing any table, relation or query, you can always create an auto report with a single click, as in step 4 below. To get the most out of this feature though, it is best to select the columns, sort order and filter conditions for the report first , as follows:
In table grid view, select the columns you want to see in the report – if you start with all columns, use the right mouse button to hide the columns you don’t want (for more details on column selections, see Hiding and showing columns in a database table).
Apply any filters you want. Use the right mouse button to perform a quick filter selection; alternatively use the filter dialog for a more complex filter– see Filters for more details.
Still in table grid view, select a sort order for the report. Sorting has special significance for the auto report: data will be sorted and grouped together, with group totals appearing automatically. You can sort on multiple levels – see Sort orders for more details.
Finally, select the Report button or select Report from the View menu.
The report is initially divided into several sections separated by bars. Each bar heads its own section, in which you can display data or enter text and graphics. Here is a list of the bars and what they stand for:
Report Header - a header for the whole report on the first page
Page Header - a page header for every page (by default, the table field names)
Detail - the main body of the report, which displays the table fields
Page Footer - a page footer for every page
Report Footer - a footer for the whole report on the last page, which automatically displays total summary information for some of the fields
Note that the Draw toolbar is also displayed.
See: