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!

how to add columns in an existing report with union in it.

Discussion in 'Oracle Forms and Reports' started by narrasai27, Jun 10, 2013.

  1. narrasai27

    narrasai27 Active Member

    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    100
    now i have to add 1) order_no 2) invoice_date 3)term from ra_customer_trx
    and
    4) receipt_date from ar_cash_receipts but the query in the report is as the script that i have attached containing union in it so how could i add the columns in the script below or else should i take an other query and give the data link to this.

    pls give the solution for this question.
     

    Attached Files:

  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hai,
    i think No need to add another query. Just display columns in same query which already have those tables in query. In first query take 1) order_no 2) invoice_date 3)term and 4) null receipt_date and in second query also give null and alias name for columns which are not there....

    Hope This will help you.....

    Jagadekara Reddy