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!

BI (XML) Publisher Report: convert rows to columns

Discussion in 'PeopleSoft, Siebel, JD Edwards, Primavera' started by sreyas, Jun 16, 2014.

  1. sreyas

    sreyas Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    We have developed SQL which pulls large data. I need to format the data on the Report properly.

    Requirement -

    Now in report we have 3 rows in green at top of the sheet and 3*31 (columns*rows) in Yellow below.Grouping is done by 3 green rows i.e. Contract.

    I need to show Contracts horizontally (column wise) and this number would be dynamic data and there can be n number of contracts.

    For each contract I have to show the Yellow Highlighted Columns (grouped) and they also need to be displayed column wise on the Report (dynamic data) according to the Contract displayed in green.

    Please help us to solve this issue
     
  2. jagadekara

    jagadekara Forum Guru

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

    Provide sample data...