Specify Fields (New Layout/Report assistant)

Specify Fields (New Layout/Report assistant)

In this panel of the New Layout/Report assistant, you select the fields that you want to include in the report. The fields appear on the layout in the order you specify.

To

Do this

Include a field in the report

In Available fields, double-click the fields you want, in the order you want them to appear.

Or, select one or more fields, then click Move.

To choose a field from another table, first choose the table from the list of tables, and then choose the field. You can also create a new field or table by choosing Manage Database from the list of tables.

Remove fields you've already selected

In Fields shown on layout/report, double-click the field you want to remove.

Or, select one or more fields, then click Clear.

Change the order of the fields in the report

In Fields shown on layout/report, drag the double-arrow next to the field name to a new position.

Notes and tips

•

To select more than one field name in the field lists, Shift-click to select contiguous fields. Ctrl-click (Windows) or Command-click (OS X) to select non-contiguous fields.

•

If you are creating a sorted report, include the fields you want to sort by. If you are creating a report with grouped data, include the break fields. Even if you don't want sort or break fields to appear in the body of the report, FileMaker Pro needs them to structure the report correctly. If you see in a later panel that the field you want isn't available, click Back to return to this panel.

•

After you finish the assistant, you have complete control over placing or removing fields or portals in Layout mode.

•

In a report with grouped data, add the break field twice if you want it to appear in the body part as well as in the subsummary part.

Related topics

Creating a layout

To	Do this
Include a field in the report	In Available fields, double-click the fields you want, in the order you want them to appear. Or, select one or more fields, then click Move. To choose a field from another table, first choose the table from the list of tables, and then choose the field. You can also create a new field or table by choosing Manage Database from the list of tables.
Remove fields you've already selected	In Fields shown on layout/report, double-click the field you want to remove. Or, select one or more fields, then click Clear.
Change the order of the fields in the report	In Fields shown on layout/report, drag the double-arrow next to the field name to a new position.

Was this topic helpful? Send feedback.