Crystal chart problem

[problemman1]

Hi all

i need help badlyCry
i need to create a simple chart where the x axis shud show the names of the months and y axis the value for each month..
i have a table in oracle from which im selecting 5 rows(which are the values for 5 months)..now i need to display these 5 values in the data axis...
for jan=0.5,feb=3.5,mar = -7.4 ,apr = -2.5324234, may = -18.34342
how can i achieve this...if these values where under one name like for eg 'VALUES' it wud have been easy...but now all these 5 values are with 5 difffernt header names....Kindly help me...any doubts do not hesitate to ask.....

 

[Turkbear]

Hi,
What is the structure of the Oracle table?
Is it 2 columns, Month and Value?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[senamuna]

Hi,

It seems the structure is ID,Jan,Feb,Mar...

Use the UNION operator as shown below and you will get the result set as ID,Month,Value.

SELECT ID,Month,Value
FROM (
SELECT ID,Month='January',Value= Jan FROM table WHERE ID=selectedID
UNION
SELECT ID,Month='February',Value= Feb FROM table WHERE ID=selectedID
UNION
SELECT ID,Month='March',Value= Mar FROM table WHERE ID=selectedID
-- You got the idea

) AA


You have to use the Command option (or a stored procedure) to use this script with Crystal.

Hope this helps.