Forum Stats

  • 3,750,348 Users
  • 2,250,159 Discussions
  • 7,866,944 Comments

Discussions

Dynamic pivot query?

ab_roman
ab_roman Member Posts: 20
edited Apr 29, 2019 3:18AM in SQL & PL/SQL

Dear All,

I have a table data like below: table may have more record with different date.. if the table has more rows report colums need to increase to display the values.

param1 date1 value1 value2 value3

param2 date1 value1 value2 value3

param1 date2 value4 value5 value6

param2 date2 value4 value5 value6

...

I want to display like below in apex report:

Paramdate
date
date...
param1 value1 value2 value3value4value5value6
param2value1value2 value3value4value5value6

I can't find a way to do this, could you please help...

any help is highly appreciated.

kind regards,

roman

Tagged:
ab_roman

Answers