To customise your brochure reports, go into the ‘Print’ section within a property record. From here select the report that you wish to edit and click ‘Edit’. A popup will appear containing the details of the report, click ‘Edit Report’

You can also copy reports. This gives you the opportunity to rename them and edit them so you have more report options to choose from

Adding Merge Fields

There are a number of merge fields available for brochure reports. Merge fields are added by selecting the ‘Field’ tool and entering the expression for the merge field you require.

e.g. – (1.) Select the ‘Field’ tool, (2.) highlight the area you want to create the field in and (3.) enter the expression

 The expression used here ‘v_property.property_status’ will tell us the status of the property.

Adding Merge Fields Including a Seek

Some Merge Fields also require a ‘Seek’ to locate them. This is entered in the ‘Print when’ tab of the ‘Field Properties’ window in the ‘Print only when expression is true’ section

Merge fields that require a seek will be highlighted in bold and include both an ‘Expression’ and a Seek/’Print When’

Adding Images

If you wish to add images to your reports, select the ‘Picture/OLE Bound Control’ Tool and highlight the area you want to add the image to. Then click the grey box to the right of ‘Control Source’, this will open your windows file explorer where you can select you image.

For number 17 (EPC Graph) you need to insert an image instead of a field.

Select the ‘Picture/OLE Bound Control’ and highlight the area that you want to add the EPC graph to. You then need to enter the following command into the ‘Control source’ box:

- Control source: gc_attachdir+alltrim(v_property.Energy_graph)

Then go to the ‘Print when’ and enter the following command into the ‘Print only when the expression is true’ box:

- Print only when the expression is true: FILE(gc_attachdir+ALLTRIM(v_property.energy_graph))