Line Graph in JDeveloper JClient

Apologies in advance for asking a 'simple' question but I cannot work out how to produce a line graph in a JClient and I have found no examples/tutorials which do so. Would someone indicate where I'm going wrong?

Here's what I do:

I have a Stock table (STOCK_ID,NAME) and a Price table (STOCK_ID,DATE,PRICE). I create an empty JPanel and create a Stock Table (StockView1) on a JScrollPane and a Price table on another(PriceView2 under StockView1)).

I create navigation bars for each.
This coordinates and works fine.

I then want to display a line graph x=date y=price for each stock as I navigate through the stocks.

So I drag PriceView2 as a graph onto the JPanel.

This causes a BIGraphDef1.xml and PriceView3 (seen under Panel1UIModel.xml) to be created.

I open BIGraphDef1.xml and change the graph type to line.

I then click on PriceView3 which opens the Customize Graph Binding dialog, Select Data Collection.

Now I assume that I should select the 'Multiple Data Selection' radio button.

I can then only progress to the next page 'Select Attributes' if I select StockView1 as the 'Data Collection' which defaults 'PriceView' as the 'Data Collection accessor'.

Then whatever combination I try on that page I cannot produce a line graph - usually getting the 'insufficient number of columns' message.

Should I be creating another view on the data?

I'm sure the solution is simple, but obviously I have some sort of 'conceptual' problem ;(

Any step-by-step or other pointers appreciated.

TIA Received on Thu Oct 14 2004 - 12:39:13 CDT