Another Chart Labels Question

[SGTech]

I am using CR8.5 Developers edition.

The report is blank with just a chart created in the header.

The chart is based on an sql7 table with datapoints in each row.

Example:
Fields: wk_strt wk_end Total_Open End_Open
Data: 9/24/01 9/30/01 61 13
10/1/01 10/7/01 41 5

The chart generates Ok using:
On change of metrics_total.wks_strt-A
in Chart Expert.

The chart group labels appear as mm/dd/yyyy as would be expected from the column data and are in ascending order.

Problem: I need the labels to appear in "mmm dd" format due to crowding with more than 3 or 4 weeks. I prefer not to use rotation, if possible.

Is this possible with Crystal? And, if so, can someone (or everyone) share the how? I can only find appearance formatting for the labels and not the actual text.

I am new to Crystal (about 3 weeks) and hope I can share answers here, at some point, also.

Thanks for your time,
Stan

 

[MJSQA]

I have not created a chart with dates as labels but here is something you can try.
Choose to preview your report. Right click on the chart and choose Chart Analyzer. Then Right click on the label and choose Format Chart and then Selected Item. You may be able to adjust how the date is formatted that way.

 

[SGTech]

Thanks for your response MJSQA!!

Just tried those steps again as I thought I had.
I only see appearance formatting available, such as font, rotation, alignment, frame, etc., not the actual text.

Any other suggestions welcome!

If I stumble across a solution, I'll share it with you!

Thanks again, Stan

 

[MJSQA]

I have looked into this as a matter of curiosity now. I think the problem is that it is seeing the label as text rather than as a date field. What if you created a formula that would put the date in the format that you want it in and then use the formula as the label?