How to show query values in LedgerTransStatement report?

In G.L>>Reports>>Transactions>>Dimension Statements, the LedgerTransstatementDialog Form opens. Here by clicking the select button, the Inquiry Wizard opens and we select LedgerAccount, Department, CostCentre开发者_C百科 and Purpose and click ok. Now the selected Fields will display in the ranges grid of the LedgerTransStatementDialog Form.

My requirement is to get the Purpose (Field, Criteria) to the LedgerTransStatement report. In first Pageheader we can see MainFocus and MainFocusdescription, in the same way I want Purpose to be displayed in My report.

This can be done with some programming on your part.

Take a look in \Forms\LedgerTransStatementDialog\Methods\loadTmpSysQuery which loads the query values in a temporary table.

Do a similar method in the report, load it in two arrays instead (one for label, one for range value), then make two display methods, one for each of the arrays.

Change the PageHeader section to include several fields of the display methods, remember to change the ArrayIndex property to 1, 2, 3 and as many you bother or have space.