User manual

Chapter 3 | Creating databases 74
You can also view summary data in Table View, which lets you group your data by one or more
columns (fields) and check subtotals for each group of grand totals for the table. The summary
results recalculate and update in real time when you change data values in Table View. You can
also create charts directly from Table View. For more information on creating dynamic reports and
quick charts, see Help.
List view
A List view layout contains the fields you select, in the order you specify from left to right across
the page, with field names as column headings. This layout is good for viewing or printing multiple
records in rows (a list of records). If there are many fields, columns will extend beyond the right
page margin of the layout. To prevent this, you can constrain columns to the page width.
In the assistant, you can choose to:
1 add header and footer parts with static text (like your company's name), dynamic text (like the
page number or current date), or a graphic (like your company logo)
1 group records by sorting
1 save information in a script to rerun the report (for example, switch to the report layout, sort the
data, and pause to let you preview the report)
You can modify any of these options after you complete the assistant.
Report
A Report layout lets you set up a report with grouped data and optional totals and subtotals. For
example, you can group sales data by region, then subtotal—or subsummarize—sales for each
region, and add a grand total. As with a List view layout, you can add header or footer parts and
save information in a script.
For more information about Report layouts, see Help.
Blank layout
Use a Blank layout as the starting point for a layout that you create entirely from scratch, for
example, a complex data entry screen. You add the fields and other objects you want on the layout
in Layout mode.
For more information about creating layouts and reports, see Help.