Sage 200 Report Designer - Report Designer document structure
Description

This article has been prepared and issued to you as a goodwill gesture only and Sage accepts no liability or responsibility for its use. For further support please refer to your Business Partner.

Cause
Resolution

Each document has a combination of the following sections, which you can add or remove as required.

A document can contain more than one of each header and footer type, and you can hide individual sections if required.

Each section appears only once on the design page but may appear multiple times when you generate the document.

SectionDetails

Report header

Items within this section appear once at the beginning of your document.

Page header

Items within this section appear once at the beginning of each page of your document. It usually contains information such as the document title and page number.

Group header

When you choose to group information on a document, this adds a group header section to the design page. Items within this section appear at the start of each group of information.

For example, on a customer report if you group transactions by the customer's account reference, the document shows a SLCustomerAccounts.CustomerAccountNumber Header section. It appears on the document for each customer before their transactions and you can use it to show, for example, the customer name.

Details

This section contains the data that the report is based on. It appears for each instance of data picked up by the variables in the section.

For example, if this section contained the variable for the customer's account reference, SLCustomerAccounts.CustomerAccountNumber, the section would appear once on the document for each customer record. If this section contained the variable for transaction number, SLPostedCustomerTrans.UniqueReferenceNumber, the section would appear once on the document for each transaction number.

Group footer

When you choose to group information on a document, this adds a group footer section to the design page. Items within this section appear at the end of each group of information. It's commonly used for group sub totals..

For example, if you group transactions on a customer report by the customer's account reference, the document shows a SLCustomerAccounts.CustomerAccountNumber Footer section. It appears on the report for each customer after their transactions, and can be used to show, for example, sub totals for the customer.

Page footer

Items within this section appear once at the end of each page of your report or document.

Report footer

Items within this section appear once at the end of your report or document.

With the exception of the Details section, the sections work in pairs. For example, each report header has a corresponding report footer and if you remove the report header it also removes the report footer.

To change the properties of a section on your report:

Design page > select the section > Properties pane > amend the settings as required.

If you are viewing this article from the Sage website, a list of Sage 200 Report Designer articles are available now.



Steps to duplicate
Related Solutions