SSRS 2005 YTD Line graph with zeroes in some months

[DietSquirt]

I have a line graph in SSRS 2005. My data looks like this:
Month Sales
1 40,643.00
2 34,524.00
3 68,465.00
4 24,323.00
5 60,752.00
6 25,013.00
7 51,784.00
8
9
10
11
12
Because we're part way through the year, some months have no values in them yet. The line graph makes it look like sales totally died where it swoops down to the 0 line for those months. Is there a way to deal with that?
Any suggestions will be appreciated.
TIA!

 

[xlbo]

Do you have nulls or zeroes in there?

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

 

[DietSquirt]

The dataset is returning zeroes for months 8 through 12. Sorry, I didn't specify that in my example.

 

[xlbo]

If you return nulls, your problem should go away...

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