The next step is to add fields to the report. First, click the Columns tab. The left side of this screen has the heading Tables and shows the table(s) that the report is using. The right side, which is marked Output Columns, will list the fields that are on the report.
To select the fields you wish to add, click the folder icon next to the name of the table.
A window will appear, showing all of the fields for that table.
Check the boxes of the fields you want to add to your report and click the Save button to add them. As fields are added, they will be shown in the right section of the screen, under the Output Columns heading. Add all of the fields that you wish to see on the report.
The section under the Output Columns heading shows the fields in the correct order. You can modify the order in which they’ll display on the report by dragging and dropping the fields in this area. You can also edit the properties of a field by clicking the pencil icon, or remove a field by clicking the trashcan icon.
Click the trashcan icon on a row, to remove that field from this screen. It will not be displayed when you run the report. Clicking the pencil icon will bring up the Properties window, which you can use to modify the field.
The Properties window allows you to fine-tune the behavior and look of the specific fields. To modify the properties go to the Columns tab and click the pencil icon for the field you wish to adjust.
When you do this, you will see a screen similar to the one below. The very top of the form tells you the name of the report you are working with and also the name of the field whose properties you are modifying.
The properties available to modify vary depending on the type of field (text, numeric, memo, logical, or date) chosen to modify.