Page 1 of 1

Surpress 0 or null values when using TDBCrossTabSource

Posted: Fri Sep 24, 2010 7:58 am
by 10554309
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.

Re: Surpress 0 or null values when using TDBCrossTabSource

Posted: Fri Sep 24, 2010 3:47 pm
by yeray
Hi Eric,

I'm afraid it's not possible right now. I've added it to the wish list to be implemented in future releases (TV52015171).

Re: Surpress 0 or null values when using TDBCrossTabSource

Posted: Mon Sep 27, 2010 2:08 am
by 10554309
Hi,

And what if I create series manually? Might that be an option?
If yes how I'm gone accomplish it then and you have an example doing this?

Maybe you can use the testproject attached as a reference.

Thanks,
Eric.

Re: Surpress 0 or null values when using TDBCrossTabSource

Posted: Mon Sep 27, 2010 11:18 am
by narcis
Hi Eric,

What about using bottom axis MinimumOffset?

Code: Select all

  Chart1.Axes.Bottom.MinimumOffset:=-1;

Re: Surpress 0 or null values when using TDBCrossTabSource

Posted: Tue Sep 28, 2010 2:24 am
by 10554309
Hi,

Yes that will hide the first point yes. But what if I have zero point somewhere in the middle? And what in case paging is enabled?
I'm affraid this is not gone work isn't it?

Thanks.
Eric.

Re: Surpress 0 or null values when using TDBCrossTabSource

Posted: Wed Sep 29, 2010 9:53 am
by narcis
Hi Eric,

No, it won't. If you don't want those points to be displayed at all why don't you remove them from the series?