Format types

Header Formats function similar to headers in common word processing applications. They appear at the top of each report page to which they have been applied.

Any Format can be used as a header. However, Formats intended for use as headers typically only occupy the first one or two rows in the Format Editor grid, allowing sufficient space on the page for any Body Format to be displayed.

If more than one header is to appear on a Report page, you may want to leave row 1 of the grid blank in any header Formats that are located below another header Format. This provides some white space between the headers on the report page. You can adjust the row height if too little or too much white space is appearing.

In the Master Formats supplied by MYOB, the headers that have been created contain Page Header in their name. A Format that has been added to a report for use as a header, displays as

You can use multiple header elements in a Group to facilitate various combinations of page headers. For example, you may want to use two header Formats to print both the Client Name and Balance Sheet Formats as page headers.

A page header can have conditions (see Conditional formatting) associated with it.

For example, in the Company – Small Non Reporting report, there are mutually exclusive conditions set on 2 page headers. The Page Header – Compilation Report page header Format has the condition =DB.ClientDetails.Audited=NO, while the Page Header – Audit Report page header Format has the condition =DB.ClientDetails.Audited=YES.

If the Audited field in the ClientDetails Database Map table contains a value of NO, then the Page Header – Compilation Format is used. If the field is set to YES, then the Page Header – Audit Report Format is used.

Once you have added a Format to a Report, you can use the Report Element Properties window to change the Format type, if required.

A Format that has been added to a report for use as a body Format displays as

Assigning a Format as a body Format in a report inserts it on the page below any headers used and above any footers used. A body Format contains the main flow of text on a report page.

Page breaks between body Formats can be controlled using the Page Break option in the Report Element Properties window. If you are not happy with the page breaks that are occurring within a body Format, you can change the pagination by leaving blank rows in the Format and by adjusting the margins. If you change the Format, make sure that this does not cause problems for any other reports that use that Format.

You can also set conditions (see Conditional formatting) as to when a body Format is included in a report.

Footer Formats function similar to footers in common word processing applications. They appear at the bottom of each report page to which they have been applied.

Any Format can be used as a footer. However, footer Formats typically only occupy a couple of rows in the Format Editor grid, allowing sufficient space on the page for the Format that has been assigned the role of body Format to display. You can use blank rows to provide some white space between the body Format and the footer Format on the report page.

In the Master Formats supplied by MYOB, the footers contain Page Footer in their name. A Format that has been added to a report for use as a footer displays as

You can use multiple footer Formats in a Report Group to facilitate various combinations of page footers, if required.

A page footer can be added to the Report as a whole or to a group within a report. If added to a group, a page footer prints at the bottom of each page generated for that Group.

A footer Format can have conditions (see Conditional formatting) associated with it.

For example, in the Company – Large Non Reporting report, there are mutually exclusive conditions set on 2 page footers. The Page Footer – Audited Format has the condition =DB.ClientDetails.Audited=YES, while the Page Footer – Unaudited Format has the condition =DB.ClientDetails.Audited=NO.

If the Audited field in the ClientDetails Database Map table contains a value of NO, then the Page Footer – Unaudited Format is used. If the field is set to YES, then the Page Footer – Audited Format is used.

Once you have added a Format to a report, you can use the Report Element Properties window to change the Format type, if required.