On Change of Week for Chart

[shelby55]

Hi

I'm using Crystal 8.2 reporting from an SQL database.

I have a database with one line being one patient visit. I want to create a graph showing average number of patients per week. How do I change the "registration date" field in the "on change of" to be for a week and not a day?

Thanks very much.

 

[shelby55]

Hi

I figured this out which is great but how do I change the label to show the min and max dates of the range?

Thanks.

 

[lbass]

What label? You could remove the chart title and add a section that contains a formula to act as the label, which references the report date range.

-LB

 

[shelby55]

Hi LB

Thanks for responding. Actually I mean the axis i.e. right now it is grouping per week but only showing the first day of the week: 04/04/2010, 11/04/2010, 18/04/2010. Using the first date as an example, I'd like it to show as 04/04/2010 - 10/10/2010.

Also, strangely with 8.5 I can't seem to change the format of the x-axis i.e. 04/04/10 to 04-Apr-10 - is that possible?

Thanks very much LB!!

 

[lbass]

Sorry, I don't think you can do either of those in 8.5

-LB

 

[shelby55]

Thanks LB - I didn't think so either but glad you confirmed!