I am trying to insert a graph which shows several curves coming from an Oracle database (ex: monthly customer complaints No for each factory unit).
1° It seems Oracle does not support Transform/Pivot instructions to create a crosstab query => how to go about it ?
2° The only way to generate graphs I have found in FP2000 seems
a/ to extract Oracle data in a table
b/ to insert an Excel sheet Office component taking the data from the table
c/ to insert an office chart web component plotting the data from the Excel sheet.
=> Is there no simpler way from Oracle to creating a graph ?
Thanks.
1° It seems Oracle does not support Transform/Pivot instructions to create a crosstab query => how to go about it ?
2° The only way to generate graphs I have found in FP2000 seems
a/ to extract Oracle data in a table
b/ to insert an Excel sheet Office component taking the data from the table
c/ to insert an office chart web component plotting the data from the Excel sheet.
=> Is there no simpler way from Oracle to creating a graph ?
Thanks.