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 display output Horizontally?

Discussion in 'Oracle Forms and Reports' started by jagadekara, Jul 8, 2015.

  1. jagadekara

    jagadekara Forum Guru

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

    I need to display output horizontally in my report.

    Current Output:

    col1 col2
    ----- ------
    1 a
    2 b
    3 c

    Required Output:

    col1: 1 2 3
    col2: a b c

    I can do this by rdf layout, but I need to do it by XML Publisher, because I need excel output only.

    So Any ideas?
     
  2. nilesh.dudhane

    nilesh.dudhane Active Member

    Messages:
    42
    Likes Received:
    2
    Trophy Points:
    135
    Location:
    India
  3. jagadekara

    jagadekara Forum Guru

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

    But I opt for Pivot in rtf.
     
  4. revathimano86@gmail.com

    revathimano86@gmail.com Newly Initiated

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Bangalore
    By using Pivot better then DECODE
     
  5. Chalbay

    Chalbay Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    UK
    Use listagg Funcation

    SELECT LISTAGG(product_name, ', ') WITHIN GROUP (ORDER BY product_name DESC) "Product_Listing"
    FROM products;
     
  6. jagadekara

    jagadekara Forum Guru

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

    Listagg is depend on oracle version, Right?

    Because it is showing error like below.
    ORA-00923: FROM keyword not found where expected
    00923. 00000 - "FROM keyword not found where expected"