Crystal Reports XI: Datetime in x-axis instead of date
Posted on 2009-05-18
I'm feeling really dense.
I'm using Crystal Reports XI and I'm trying to create a line graph that charts result values on the y-axis and datetime on the x-axis. The graph that I keep getting is charting only the date on the x-axis, even though the data itself is a datetime data type.
My data set would look something like this:
Result entry DateTime
2.87 5/12/09 11:37:06 AM
4.09 5/12/09 11:43:09 AM
3.98 5/12/09 1:14:54 PM
I'm charting the max of the result entry on change of datetime. But instead of getting a chart with three data points, one for each datetime listed above, I'm getting a chart with one data point (the max - 4.09) on 5/12/09 only. I need this to chart to the second, not to the day or minute.
There must be a setting or something that I'm missing but for the life of me I can't find it. I've played with setting up the chart as a date axis line chart, then setting up the group axis options such that it's a date or a time format, but the chart is leaving off seconds, or ignoring the actual datetime data and instead converting the date to a datetime stamp (e.g. 5/12/09 11:43:09 AM is charting as 5/11/09 11:59 PM), etc.
I'd appreciate it if someone could point me in the right direction. I really feel like this should be an easy fix but I just can't seem to find it.