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!

Pivoting for 5 columns in interactive report

Discussion in 'Oracle Application Express (APEX)' started by Bharat, Nov 13, 2015.

  1. Bharat

    Bharat Community Moderator Forum Guru

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

    We are trying to develop Report using 5 Columns as pivot in oracle apex 5.0 Version. But this version is restricted to pivot only 3 columns. Can anyone please suggest, whether there is a way to handle this ?
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    I didn't know APEX 5 had that restriction...can you use a view?
     
  3. Muhammad Uzair

    Muhammad Uzair Starter

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Pakistan
    Hi Bharatt!

    As I understood your question you want to a matrix report (pivot table) in Oracle APEX ?
    There is something wrong in your SQL Query. Please provide SQL Query