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,
--
Scott H.