Graphing over time when missing a minute 1

[earme]

Hello,

I have a line graph that charts a value over time by minutes. However, sometimes the database does not have any values for a minute or two. When this happens CR graphs it with the same interval, for example, it puts the same space between 10:31 and 10:32 as between 10:36 and 10:39 when values are missing. Through Access queries I have all the minutes, but then those values that were missing in the original database become Null so the chart graphs them as zero values, which I don't want. When only one minute is missing I can take the average value of the record before and after it using previous and next. I don't know how to handle cases when there is more than one minute of data missing though.
Any suggestions?

Thanks in advance!
Evie [sig][/sig]

 

[DanWalter]

Evie: We're having EXACTLY the same problem! Did you find a solution for it? If so, I'd be eternally (well, almost!) grateful to know what it is! Thanks so much.

Dan

 

[MalcolmW]

I can't imagine how you could possibly do that from within Crystal Reports, as the previous and next only refer to the immediately adjacent rows. I'd say your best bet is to dress up the data going to SCR - though that may not be trivial either. Malcolm
wynden@telus.net

 

[earme]

It's been a while, but I think I ended up adding all the times to the table before it got to the Crystal Reports (using a new table query in MSAccess) and then using Crystal Script if a time had a blank corresponding value, it used the last valid value and filled it in. So, I had a straight line, which I wasn't thrilled about, but decided to live with.
Sorry I couldn't be more help!
Evie