Problem with sorts in graph

[jmfox2]

I have a graph that is not sorting the graph variables correctly. The data is grouped by location, department and category with additional sort on fiscal year/period (ie: 200301 text field). Graphs look good until the non-grouped sort field fiscal year/period. The data comes out looking like 200304, 200305, 200306, 200301, 200302, 200303 -- sometimes. The data comes from an Access table that is sorted in the order I want it in.

Any ideas????

 

[Dan3D]

Well the sorting is done by CR before it contacts our chart engine so this is likely a CR bug.

If you don't get a good solution, then be advised that our replacement library for CR which is called CRChart has a @SORT function that would solve this for you since we could do our own sort AFTER CR gave us the data.

Regards,

-Dan @ 3D (The folks who make the charting library in CR)

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com