1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Transactions splitting into 2 groups based on ledger currency

Discussion in 'Oracle Forms and Reports' started by Harishk.569, Aug 7, 2015.

  1. Harishk.569

    Harishk.569 Starter

    Likes Received:
    Trophy Points:
    Hi All,

    For standard "Account Analysis Report", Client need currency parameter
    For Example, If we select currency as 'AED' then report should show only AED currency transactions
    Otherwise Currency value should be 'ALL'. Means it will display all currency transactions for single ledger account.
    We customized report, added P_CURRENCY parameter in query using decode function
    decode(p_currency,'ALL',gjh.currency, p_currenncy).

    In report output, transactions are splitting into 2 groups based on currency and displaying in different pages.

    For example, ledger account 1036373 having transactions in 'AED' and 'BHD'. AED transactions are displaying in one group and 'BHD' transactions are displaying in other group. Attached output image file and data template xml file for reference.

    Actually all transactions should display in one group in one page as same as standard report.

    Could you please anyone help me to solve this issue..

    Thanks & regards,

    Attached Files: