Surpress 0 or null values when using TDBCrossTabSource
Posted: Fri Sep 24, 2010 7:58 am
Hi,
I have a dataset and want to remove/surpress 0 values.
What I am using and need is a TDBCrossTabSource for showing summaries in a chart.
Sometimes a record can contain a 0 value and I like to be able to leave them out of the chart before the specified seriespoint is drawn. By filtering the dataset on records with a value greater then 0 I get less records already. The TDBCrossTabSource component creates series but seems to need an equal number of records to create those series. And is automatically drawing those 0 zero based points. If I use this for example : Series1.SetNull(ValueIndex), then the seriespoint isn't shown but the layout of the chart becomes a bit messy I think.
How can I make sure that all points are drawn on the total width of the TChart as it is done when there are no 0 zero values?
See image attached for a screenshot what the issue/problem is.
Thanks,
Eric.
I have a dataset and want to remove/surpress 0 values.
What I am using and need is a TDBCrossTabSource for showing summaries in a chart.
Sometimes a record can contain a 0 value and I like to be able to leave them out of the chart before the specified seriespoint is drawn. By filtering the dataset on records with a value greater then 0 I get less records already. The TDBCrossTabSource component creates series but seems to need an equal number of records to create those series. And is automatically drawing those 0 zero based points. If I use this for example : Series1.SetNull(ValueIndex), then the seriespoint isn't shown but the layout of the chart becomes a bit messy I think.
How can I make sure that all points are drawn on the total width of the TChart as it is done when there are no 0 zero values?
See image attached for a screenshot what the issue/problem is.
Thanks,
Eric.