Dundas chart line graph question...

[bessebo]

Hi,
I am using Dundas charts with SSRS and I have a line graph. I have an issue where I want the graph to show a break in the data if there is no data. What it is doing now is actually connecting the dots by drawing a line from one point to another regardless of where there are actually data points along that line. Is there any way, with a line graph, to show the break in the data?

Best,
Bessebo

 

[xlbo]

Not sure but in general, check whether you are returning a NULL value rather than a 0 value - that normally does the trick with charting...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[bessebo]

Hi xlbo,
Thanks for the post but could you elaborate on what you are saying here? Where am I checking whether I am returning a NULL value rather than a 0 value?

Thanks,
Bessebo

 

[xlbo]

In the SQL statement itself, check whether you are returning NULL or 0. I would imagine you are currently returning 0 and may need to change that to NULL

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[bessebo]

This is a trip graph which simply shows temperature on the Y axis and date/time on the X axis. I am excluding a portion of the trip in the SQL statement so there is actually a break in the data. So for that portion of time there is no data (no time data or temperature data). So the data looks like this:

11/29/2009 10:00AM 35.1
11/29/2009 10:15AM 36.7
11/29/2009 10:30AM 35.5
12/03/2009 08:00AM 33.1
12/03/2009 08:15AM 32.9
12/03/2008 08:30AM 32.0

I have actually submitted this question to Dundas and am working with them on this issue. It's funny, but they asked the same question as you did and I'm awaiting their response.

Thanks,
Bessebo

 

[xlbo]

You need to have the data point there if you want to show a break in th data...your data set would need to be something like:

11/29/2009 10:00AM 35.1
11/29/2009 10:15AM 36.7
11/29/2009 10:30AM 35.5
11/29/2009 23:59PM NULL
12/03/2009 08:00AM 33.1
12/03/2009 08:15AM 32.9
12/03/2008 08:30AM 32.0
12/03/2008 23:59PM NULL

or similar - basically, if there is no logical gep in teh data, you won;t be able to stop the lines joining up - that isn;t specific to Dundas - that's general charting methodology. doesn;t really matter what time the break is entered in, you just need a null record at the end of each day by the looks of it to stop 1 day bleeding over into the next

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[bessebo]

Hi Geoff,
You ended up giving me the proper solution although, in addition to what you mentioned, I also needed to add a line of code into the Dundas chart.

ser.EmptyPointStyle.Color = Color.Transparent

It essentially hides the NULL points. Without this line it still tries to draw a line between the last point before the break and the first line afterwards.

Thanks so much for your solution!

Best,
Bessebo