Line Chart - multiple series ploting data from dataset one series incorrect

Stimulsoft Reports.NET discussion
Post Reply
jing
Posts: 50
Joined: Fri Jan 26, 2007 12:47 am
Location: New Zealand

Line Chart - multiple series ploting data from dataset one series incorrect

Post by jing »

I have created a line chart, where x-axis values are Dates (Date Time Sent) and y-axis values are Disk usages. These data were obtained from a datasource.
Datasource "DiskUsages" looks something like
Drive | DiskUsage | DateTimeSent
C:| 39.3| 22/7/2006
D:| 4.6| 22/7/2006
E:| 3| 22/7/2006
C:| 39.9| 24/7/2006
D:| 4.6| 24/7/2006
C:| 40| 2/8/2006
D:| 6| 2/8/2006
E:| 5| 2/8/2006

On my line chart, I have 3 series, one for each of the Drive letters. Series for drive C and D are fine.
My problem is with the series for drive E.
As you can see from the datasource table above, drive E does not have data for 24/7/2006.
So on the line chart, there should only be 2 data points, one at 22/7/2006 and one at 2/8/2006. Instead, I have 2 data points, one at 22/7/2006 which is fine, but one at 24/7/2006. The diskusage is correct at 5GB, but not ploted on the right date!!!

How can I fix this problem? I have looked at the properties of the chart and on the forum, I haven't manage to find any thing...

any help will be GREAT

thank you very much
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Line Chart - multiple series ploting data from dataset one series incorrect

Post by Edward »

An AutoSeriesKeyDataColumn property has one restriction on use. The count of the values for axes must be the same for all series.
May exists a situation when a count of points differs for the collection of the autoseries. But all series will be output in correct way only when on the X Axis will not exists a "holes" (not filled values).
So if you are using autoseries, please provide the same count of values for each autoseries.

So if you will define an additional row

E:| 3 | 24/7/2006

then your "E" series will be shown in the correct way.

Thank you.
Post Reply