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 use column from another group into other in reports

Discussion in 'Oracle Apps Technical' started by sambhaji, Jan 23, 2014.

  1. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi all,

    How to refer one col1 from group g1 into other group g2 in oracle reports ???

    Regards
    Sambhaji
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    What you exactly want?

    For example you have g1 and g2 groups. In g1 empno,ename is there. In g2 you need to pass empno or ename? or you need to display empno or ename along with g2 columns in output?
     
  3. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi,

    I have two groups 1)g_headers 2)g_break_lines. I want to refer two columns from g_break_lines into g_headers. In g_headers there is one formula column in which i want to refer these two columns.But it is giving frequency error.

    Note: there groups are joined by the po_header_id .

    Regards
    Sambhaji
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    you just give : (colon) in front of column name. ex: in formula column if u want use it in where clause then use like below...

    where g2.po_header_id= :po_header_id

    here :po_header_id from g_headers group.
     
  5. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi ,
    If i want to use the column in calculation then only can i refer it by group name???

    And also if two groups are not linked then can i use same method???

    Regards
    Sambhaji
     
  6. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    No! In select statement also you can display by using same method. And no need to link between groups to display like this.