Crystal Line Chart

[Guest]

Hello:

I am trying to use Crystal Reports from VS.NET 2003 to produce a simple line
chart, where the x axis represents the number of measurements taken and the y
axis represents the range of measurement values. There are two sets of points
or measurements, so I would like a line on the chart for each set of values
(two lines).

I can produce the line chart on a VB.NET form correctly using an
Infragistics UltraChart obeject. The data points are assigned to the
datasource of the UltaraChart in the horizontal fashion (rows) where the data
looks like:

Open Flow +000.1 +001.1 +000.3 +000.4 -000.4
Check Flow +000.3 +000.5 +000.4 +000.6 +000.2

The above data creates a line chart with an x axis of 1 through 5 and a y
axis from -.4 to +1.1 with a line across the chart for each set of data (one
for open flow and one for check flow).

The problem is producing a line chart with Crystal Reports. I have tried
creating an ADO.NET dataset with three columns where the index column is a
counter included in the query output.
Index Open Flow Check Flow
1 +000.1 +000.3
2 +001.1 +000.5
3 +000.3 +000.4
etc...

I get a CR line chart where the x axis is correct but the y axis is 0 to 1
and the data is not plotted correctly. The data settings on the line chart
are "On Change of" Indx and "Show values" on both sets of data.

I can enter the data either in columns or in rows within Excel, click on the
Excel chart wizard, select line chart and get exactly what I’m looking for
but I can’t seem to get this to work in CR.

Does the data have to be presented to the CR line chart in a horizontal
(columns) fashion? If so, how is this done? I'm open to suggestions.

Thanks,

 

[Robert Dede]

Hello,

Not sure about Crystal's use, but it may be quicker to use UltraChart to
export a temp image to be embedded into the report as a simple picture. I
know we have customers often doing this (using ProEssentials) as Crystal's
charting is not so robust, especially with technical data.

best regards,

Robert Dede
Gigasoft, Inc.
www.gigasoft.com