Modification in existing report

manishkutar
manishkutar Member Posts: 19
edited 2011-03-25 in NAV/Navision Classic Client
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>
Manish Kutar,
Senior Technical Consultant
manishkutar@gmail.com

Answers

  • abhinav0408
    abhinav0408 Member Posts: 35
    Did you tried grouping on Customer No.
  • manishkutar
    manishkutar Member Posts: 19
    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.
    Manish Kutar,
    Senior Technical Consultant
    manishkutar@gmail.com

Categories