SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLDeveloper report: open hi-lo-close chart type report not working

ACoronelJun 20 2016 — edited Jun 21 2016

Hello.

I am trying to build an "Open Hi-Lo-Close" chart report using SQLDeveloper Reports version 4.1.3.20

I took a completely fabricated SQL query used to obtain data. It is

select 'GOOG' Stock, 100 Open, 120 High, 90 Low, 110 Close from dual union all

select 'MSFT' Stock, 80 Open, 100 High, 70 Low, 90 Close from dual union all

select 'ORCL' Stock, 60 Open, 80 High, 50 Low, 70 Close from dual union all

select 'AAPL' Stock, 30 Open, 50 High, 20 Low, 40 Close from dual union all

select 'INTC' Stock, 45 Open, 55 High, 15 Low, 35 Close from dual

I might as well have used

select 'GOOG' Stock, 90, 'Low' from dual union all

select 'GOOG' Stock, 100, 'Open' from dual union all

select 'GOOG' Stock, 110, 'Close' from dual union all

select 'GOOG' Stock, 120, 'High' from dual union all

select 'MSFT' Stock, 70, 'Low' from dual union all

select 'MSFT' Stock, 80, 'Open' from dual union all

select 'MSFT' Stock, 90, 'Close' from dual union all

select 'MSFT' Stock, 100, 'High' from dual union all

select 'ORCL' Stock, 50, 'Low' from dual union all

select 'ORCL' Stock, 60, 'Open' from dual union all

select 'ORCL' Stock, 70, 'Close' from dual union all

select 'ORCL' Stock, 80, 'High' from dual

or anything my imagination comes up with, as I found no examples describing how this report expects to find information.