Repeating rows for Database Map data

Accountants Enterprise in Australia only

You apply repeating to a Database Map item within a format when the Database Map table you are referencing in the format is a multi record table. The repeat setting allows room for all the data values entered for the fields in the table.

If the Database Map table is a single record table, you do not need to apply any repeating.

To repeat rows for Database Map data within Report Designer (on the Database Map tab)

Create a Database Map reference in the cell that forms the intersection between the row in which you want the first value displayed and the column in which you want the values to appear. For example, =DB.FinancialLiabilities.FinterestRateAmount. Consult the table entry on the Database Map if you need to make sure that the table and field names you are entering are correct.
Right click on the row label (grey column) of the row in which you entered the Database Map reference.
Select Repeat from the right-click menu. The Repeat Settings window opens.
Select the Repeat for Database Map Table option.
In the list box, select the path to the folder containing the database field to which you created a reference.
Click OK to apply your changes and close the Repeat Settings window.

Your changes are not saved until you save the format.
To view the results click the Preview button. You should see a row displayed for each record in the database. If you see a formula displayed (i.e., ‘=<table name>.<field name>’) then you have made an error in entering the table and field names, which you will need to correct.

You can set a print condition on the row you have set to repeat. This condition will be applied individually to each row that is returned.
The data that is displayed when the report is run will depend on the level (Client or Practice) at which you are running Report Designer, the client ledger from which you have opened it, and whether or not the table you are referencing is set to contain multiple values.