Modification in existing report

manishkutar

I have one report with id: 120 (Aged Accounts Receivable)

Now whenever i run report and enter "Period Length" then select "Print Details" the report shown is proper but I need to modify.
Report now showing preview as follows:

10000 //Customer No.
Posting Date | Doc. No. | Currency | Amount<- //Modified text field
03.03.2011 | 005 | INR | xxx
Total : xxx

10000 //Same customer no. as above
03.03.2011 | 006 | USD | xxx
Total : xxx

10000 //Same Customer no.
04.03.2011 | 007 | EUR | xxx
Total : xxx

Preview I require should be displayed as:
10000 //Customer no.
Posting Date | Doc. No. | Currency | Amount
03.03.2011 | 005 | INR | xxx
03.03.2011 | 006 | USD | xxx
04.03.2011 | 007 | EUR | xxx
Total : xxx

Just give me solution for how to combine the same customer no. with different currency code.
I think that it may be related to code in data item <TempCustLedgEntry> and <CurrencyLoop>

abhinav0408

Did you tried grouping on Customer No.

manishkutar

Ya I tried.
After trying various combinations I got solution. This issue was related to sections and Text fields placed in it.
I placed <Title> i.e. Posting Date, Amount, Currency, etc in Header of preceding data item..
And placed <Total> field in Footer of same data item which I used above for header.