Line chart displaying null values as zeros

Stimulsoft Reports.NET discussion
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Line chart displaying null values as zeros

Post by HighAley »

Hello.
mihiri1 wrote:What was the workaround for this issue?

I use SS 2011.1.919.
Please, describe our issue more detailed.

Thank you.
mihiri1
Posts: 12
Joined: Tue May 15, 2012 3:00 am
Location: Brisbane, QLD

Line chart displaying null values as zeros

Post by mihiri1 »

I have a series which has 0 values and null values.
I need to show zero values as Zero on the graph
But I do not want to show the null values as Zero. For Null values, I do not want it to show any thing on the graph, not even Zero.

but as it is both Null and Zero values are shown as Zero on the graph.

How to change this, please?

Thank you
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Line chart displaying null values as zeros

Post by HighAley »

Hello.
mihiri1 wrote:I have a series which has 0 values and null values.
I need to show zero values as Zero on the graph
But I do not want to show the null values as Zero. For Null values, I do not want it to show any thing on the graph, not even Zero.

but as it is both Null and Zero values are shown as Zero on the graph.

How to change this, please?
What type of Series do you use?

Thank you.
mihiri1
Posts: 12
Joined: Tue May 15, 2012 3:00 am
Location: Brisbane, QLD

Line chart displaying null values as zeros

Post by mihiri1 »

Line Chart Series
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Line chart displaying null values as zeros

Post by HighAley »

Hello.

In the Line Chart Series if you set the Show Nulls property to False then the Null values will not be shown but zero values will be shown.

Thank you.
mihiri1
Posts: 12
Joined: Tue May 15, 2012 3:00 am
Location: Brisbane, QLD

Line chart displaying null values as zeros

Post by mihiri1 »

hi, thanks but it is not available in SS 2011.1.919.
In which release can I find it first?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Line chart displaying null values as zeros

Post by HighAley »

Hello.
mihiri1 wrote:hi, thanks but it is not available in SS 2011.1.919.
In which release can I find it first?
There were several improvements. Please, update to the latest prerelease build.

Thank you.
Morgan
Posts: 11
Joined: Wed Jun 05, 2013 3:52 pm

Re: Line chart displaying null values as zeros

Post by Morgan »

I am still having this issue using the latest published version as of June 19, 2013. On a Line Chart, the chart shows a data point at zero for a NULL value, when it shouldn't have a data point at all (Show Nulls is set to False, Convert Nulls is set to False, SQL statement explicitly returns a Null for these cases). The argument is not null, because I still need it for spacing, but the value is null.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Line chart displaying null values as zeros

Post by HighAley »

Hello.

Could you send us a report template with sample data which reproduces the issue for analysis.

Thank you.
Post Reply