CR 9 - ? about graphing order

[LMCRYER]

I am in CR 9, reports deployed using CE9.

I have a report which brings in data (correctly) grouped by 2 things -

Group A = Project Number
Group B = PRD (period) = this is a 4 digit number representing fiscal year, fiscal period

The problem is that the user doesnt want to SEE it in the 4 digit # (but it needs to be ordered that way).

I got around this by leaving my grouping the same, and then
creating a formula to make the 4 digit into what the user wanted (example = 0412 became APR 04, 0501 became MAY 05)

This works fine for the data part but when I GRAPH on this data, it still shows the 0401 (numerical) on the chart - if I tell it to chart by the formula then it comes in alpha order (Apr 04, Apr 05, Apr 06)....

I need it to stay in the same order but display on the graph differently -- any ideas on how to go about this?



LMC cryerlisa@hotmail.com

select * from Management where proj_mgmt_skills <> NULL

0 records returned

 

[Dan3D]

You might get some help playing around with the macros in our CRChart replacement library. I don't fully understand your problem, but there are macros for replacing data labels and doing some types of sorting, maybe one would be helpful. If you want to try an evaluation version, go to

http://www.threedgraphics.com/tdg/noteworthy/crystalreports.asp

DISCLAIMER: This product costs money. I work for the company that makes this product. There may be other solutions out there that I am not aware of.


Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com