Columns Tab (Reports)

How do I

When displaying or printing reports, use the Columns tab to choose which fields you want included in the report.

  • To change report columns, highlight a report in the Select a Report window and click the Columns button.

Sage 50 displays the following field options:

Select All/None: Select this button to include all available fields in the report. The Show check box will be selected for each field. Select None to clear the Show check box for all available fields in the report.

Field Settings: This is a list of fields that you can include on the report. You can decide whether you want to show a field or not, and for some fields you can decide whether you want to show the field name as a title, or have a column break follow the field.

Show: Select this check box to include the field in your report. The fields are listed in the report in the order that they appear here.

Title: Select this check box to display the field name as the title for a column. Note that this differs from the Fonts tab, which lets you set options for the styles of the main titles for the report. The Title check box is only available for those fields where Show is selected.

Column: This identifies the data field to be included.

Column Break: Select this check box to insert a column break after the selected field. If you want to place more than one field in a column, first select the Show check box, then clear the Break check box. This means there will not be a break (column) between the fields. You will notice that some fields cannot be in the same column and the program will automatically place a break between these. See a column break example.

Column #: This identifies the order of columns and the column number in which the field appears. To change the column number, select the Break check box of the previous field. If the Show check box for the previous field is not selected, selecting Show will also change the column number.

Move Up: Use this button to move a field up in the report list. To move a field up, highlight the field you want to move and select the Move Up button. The field moves up one place in the list.

Move Down: Use this button to move a field down in the report list. To move a field down, highlight the field you want to move and select the Move Down button. The field moves down one place in the list.

What do you want to do next?