By the end of this session, you will be able to use Vision XL Report Designer that is used to customize the format of the data extracted to Excel and is available in the Reference File Fill, Data Fill and Extract Transactions functions. The Report Designer enables a much greater degree of flexibility in the formatting of Vision reports, which are 'snapshots' of data.

Using the Report Designer definition form, you can format the information to be output including the location of output items, subtotaling information, creating page breaks and titles, inserting filtered columns and inserting section headers.
Formatting similar to Excel is available in the Report Designer including decimal places, colors, font types and font sizes.
Excel formulas can also be used to perform calculations on the extracted data. For example, a cell can be defined to calculate the average purchase price by dividing the cells that are defined to extract values for stock purchases and quantities to determine the average unit cost of purchases.
Only one design can be created for each set of definition data for each function.

Create and save as a Workbook File the following Extract Transactions report:

In Report Designer you will now define the following report sections:

The header and subtotal rows will be inserted every time there is a change of debtor. Also, the periods will be totaled within each debtor. You will also apply different formatting to each section. You name the grand total of the out of balances and then use the name created to calculate what percent of the total out of balances can be related back to each debtor.
You will now specify that in the Detail Section, Transaction Date is output in cell A1 and Base Amount goes to cell B1. Click on LA\Transaction Date and drag it to the layout window. When you drag an output data item to the layout grid, you are presented with the following menu:

You will now specify that in the Detail Section, Transaction Date is output in cell A1 and Base Amount goes to cell B1. Click on LA\Transaction Date and drag it to the layout window. When you drag an output data item to the layout grid, you are presented with the following menu:

Select:

Click on the Item menu. Repeat the same procedure for the LA\Base Amount. The result window will look like this:
Click here to see the screenshot

Click  the Format Cells button to format cells.
You are now going to add a Header/Sub-total section that will have Account Code and Name and a Total calculated, as well as listing transactions, for each different Account.
Click here to see the screenshot