Data on X-Axis

[lthompson]

Hi,

I'm using Crystal Reports 8.5 to generate a report for the daily mail flow/utilisation of our mail server.

I have the sql query functioning perfectly and I'm have produced a nice graph, however the problem I'm having is while the y axis label contains the required information (no. of mails) the x-axis will only return a row count (eg numbers 1 through to 200) instead of a date or time range.

For example the y axis should contain for each point the date eg 2/3/02 3/3/02 etc. however it contains the value's 1, 2, 3 etc.

How do I change this to put the required information on the x axis?

 

[lthompson]

Hi,

I'm sure this is easily done, but I can't find anything in the documentation or on crystal's web site. I hope someone can help as I've been stumped on this for days!!!

I'm using Crystal Reports 8.5 to generate a report for the daily mail flow/utilisation of our mail server.

I have the sql query functioning perfectly and I'm have produced a nice graph, however the problem I'm having is while the y axis label contains the required information (no. of mails) the x-axis will only return a row count (eg numbers 1 through to 200) instead of a date or time range.

For example the y axis should contain for each point the date eg 2/3/02 3/3/02 etc. however it contains the value's 1, 2, 3 etc.

How do I change this to put the required information on the x axis?

 

[Andie]

You may already by doing this, but do you have the date range selected for "On Change Of?"? I actually use v7 but I would guess there is something similar for v8.

If that isn't the problem, the only other thing I can think of is to make sure that your date range is formatted correclty.