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!

Help Needed on XML Publisher Report

Discussion in 'Oracle Apps Technical' started by club, May 6, 2012.

  1. club

    club Active Member

    Messages:
    31
    Likes Received:
    1
    Trophy Points:
    185
    Hello,

    I m having one requirnment in XML Publisher report.

    In xml report i m having fields like item number,item description,lot,quantity,date etc.In the report i m able to show fields for this.
    requirnment to add on more line below where they want to print only item number and description.But problem is that for every loop if item number and description are same then it should not print every time.It should print only once.

    Lets say for eg this is actual condition

    ItemNo ItemDesc Lot Quantity
    ----------------------------------------------------
    1 ABC XYZ 10
    1 ABC
    ---------------------------------------------------
    1 ABC PQR 20
    1 ABC
    ------------------------------------------------
    2 ZXV MNO 5
    --------------------------------------------------

    I want to show like this on rtf

    ItemNo ItemDesc Lot Quantity
    ----------------------------------------------------
    1 ABC XYZ 10
    ---------------------------------------------------
    1 ABC PQR 20
    ----------------------------------------------------
    1 ABC
    ---------------------------------------------------
    2 ZXV MNO 5
    ---------------------------------------------



    Please help me on this .

    Thanks in advance.
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    May be the organization problem. Can you post some more details like XML data or rtf. By that we can help you faster.
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    Is your problem resolved. If so please post your answer here.
     
  4. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    HI Club,

    You can solve this from your query itself if you use proper group by.
    Can you let me know still you are facing the problem. If yes pass me the query i can help you out on this.

    Cheers
    Kamal (kamal.love@gmail.com)
     
  5. selvaspskj

    selvaspskj Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    55
    Can you try as attached and let me know, if yiu have issue.

    change the file name " data.txt" into data.xml and rtf_file.txt ==> rtf_file.rtf



    - selva
    selva.spsk@gmail.com
     

    Attached Files: