Graphing Question - Can anyone point me in the right direction?

[echowave]

I have a table that contains the following data:

JOB Field1_Acutal Field1_Budget Field2_Acutal Field2_Budget
--- ------------- ------------- ------------- -------------
1 10000 15000 1000 4000
2 25000 27000 1250 5650

What I would like to accomplish is to put this data on a graph but I am having a heck of a time.

The graph would include Field1_Acutal, Field1_Budget, Field2_Acutal, and Field2_Budget on the x-axis and their numeric value on the y-axis. I would like the chart to display a line or series for each record. Is this possible with Crystal Reports? If so, can anyone fill me in with a little detail to get the ball rolling. Any questions, please let me know...

Thanks in advance...

 

[synapsevampire]

If I understand you correctly, your data doesn't fit the model.

Generally you're graphing data points on the X for each row, not for different columns.

I'd suggest pivoting the data in a View or SP if possible.

-k

 

[echowave]

synap,
I had no idea that crystal reporting was limited to graphing for just each row...
If I was to pivot the data, are you saying that is should fit the crytal graphing model then? I am not really sure how to do this, could you provide a little detail? If I cannot get this to work, what would you suggest, maybe using an Excel OLE chart?
The client would like to have the ability to select which fields(columns) that they would see on the graph for one or many projects. From the selected data, a graph would be created. I am sort of stuck, as I have no idea what to do next, any help would be greatly appreciated....

Thanks

 

[Dan3D]

This is personally frustrating. As one of the guys who wrote the charting engine, I know for sure that such a simple 'pivot' is absolutely supported by the chart library, but we could never get Crystal to 'expose' it to customers.

Our replacment chart library does it with a simple @SWAP macro command. If you want, download the free eval copy at:

http://www.threedgraphics.com/tdg/noteworthy/crystalreports.asp

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com