I want to print the report in following format
------------------------------------------------------------------------
Ledger A/c Dim1 Dim2 Dim3 Dim4 Dim5 Closing bal.
------------------------------------------------------------------------

Example :
1000 A 2000.00
1000 A B 1268.78
1000 C D E 6351.14

Input :- Fiscal Year, Period & Only Ledger A/c Range.

The Closing balance will not be calculated for only one Dim, but for the Combonations of the Dimension for selected Ledger A/c.

And the same also should be calculated UPTO the period and NOT FOR the period.

The data will be collected from tfgld206 ( for opg bal) & tfgld205 for during
period transactions.

Please let me know how can I do that..??:confused:

Regards,
Nilesh

Read Example as follows:
Ledger----Dim1---- Dim2----Dim3---- Dim4---- Dim5---- Bal
1000 ----- A ------------------------------------------1000.00
1000------A--------B----------------------------------6582.36
1000-------------------------C-------D--------E-------2569.66
1000---------------------------------------------------4486.33
2001---------------B---------------------------E-------1111.98