I need to change the Sort Order of the X-Axis.
I am using 7.6.4 Dev Studio Advanced Graph.
I have created a SORT_ORDER field, but I do not want it to be printed. I've tried the NOPRINT but it still prints....

Here is my code:

GRAPH FILE MILESTONES1
-* Created by Advanced Graph Assistant
SUM MILESTONES1.SEG01.COMPLETE/I11C AS 'Complete'
MILESTONES1.SEG01.MISSED/I11C AS 'Missing'
BY MILESTONES1.SEG01.SORT_ORDER2 NOPRINT
BY MILESTONES1.SEG01.SHIPMENT_MSR AS ''
ON GRAPH PCHOLD AS HOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET HAXIS 400
ON GRAPH SET VAXIS 280
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTKPC
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setSeriesLooping(31);
setZeroValueDataTextDisplay(false);
setTextRotation(getDataText(),0);
setLegendAutomatic(true);
setTextString(getO1Title()," ");
setDisplay(getO1Title(),true);
setRiserBarGroupSpacing(0);
setMarkerSizeDefault(300);
setFontStyle(getO1Title(),0);
setDisplay(getO1Label(),true);
setAxisSide(getO1Axis(),0);
setSkipBegin(getO1Label(),2);
setSkipCount(getO1Label(),1);
setAutoSkip(getO1Label(),0);
setLabelMargin(getO1Label(),1);
setTextUnderlineType(getO1Label(),5);
setTextJustHoriz(getO1Label(),0);
setFontStyle(getO1Label(),0);
setRect(getTitle(),new Rectangle(-15360.0,14882.0,29888.0,978.0));
setFontName(getY1Label(),"Arial");
setFillColor(getSeries(2),new Color(170,70,67));
setDisplay(getLegendArea(),true);
setStackedDataValueSum(false);
setFontSizeAbsolute(getDataTextStackedTotalOnTop(),true);
setFontSizeInPoints(getDataTextStackedTotalOnTop(),10);
setTextRotation(getDataText(),0);
setFontName(getDataText(),"Arial");
setFontStyle(getDataText(),0);
setTextRotation(getO1Label(),0);
setFontStyle(getTitle(),0);
setDisplay(getAnnotation(0),true);
setTextString(getAnnotation(0),"");
setLegendOrient(2);
setFontName(getTitle(),"Arial");
setFontName(getO1Label(),"Arial");
setLabelStagger(getO1Label(),true);
setFontName(getLegendText(),"Arial");
setDisplay(getY1MajorGrid(),true);
setFillColor(getY1MajorGrid(),new Color(255,0,0));
setLineWidth(getY1MajorGrid(),0);
setBorderColor(getY1MajorGrid(),new Color(0,0,0));
setDisplay(getY1MinorGrid(),true);
setGridStyle(getY1MinorGrid(),0);
setReferenceLineValueY1(0,20.0);
setDisplay(getReferenceLineY1(0),false);
setGridStepAuto(getY1MinorGrid(),false);
setGridStep(getY1MinorGrid(),0.7);
setLineBasicStrokeType(getY1MinorGrid(),11);
setFillColor(getY1MinorGrid(),new Color(255,255,255));
setBorderColor(getY1MinorGrid(),new Color(192,192,192));
setBorderColor(getFrame(),new Color(255,255,255));
setFillColor(getChartBackground(),new Color(255,255,255));
setTopInset(getBeveledRiser(),100);
setBottomInset(getBeveledRiser(),100);
setLeftInset(getBeveledRiser(),100);
setRightInset(getBeveledRiser(),100);
setFillColor(getSeries(1),new Color(170,70,67));
setTransparentBorderColor(getSeries(1),true);
setDisplay(getBeveledRiser(),false);
setTransparentBorderColor(getSeries(0),true);
setBorderColor(getO1AxisLine(),new Color(192,192,192));
setLogScaleBase(getY1Axis(),10.0);
setBorderColor(getY1ZeroLine(),new Color(192,192,192));
setBorderColor(getY1AxisLine(),new Color(192,192,192));
setFillColor(getY1ZeroLine(),new Color(192,192,192));
setTransparentFillColor(getFrameSide(),true);
setShadowColor(getFrame(),new Color(255,0,0));
setShadowDisplay(getFrame(),false);
setTransparentBorderColor(getFrame(),false);
setFillColor(getFrame(),new Color(255,0,0));
setTransparentFillColor(getFrame(),true);
setRiserWidth(70);
setPlace(true);
setDepthAngle(0);
setDepthRadius(4);
setPlaceResize(getLegendText(),0);
setPlaceResize(getO1Label(),0);
setPlaceResize(getY1Label(),0);
setTransparentBorderColor(getChartBackground(),true);
setLegendPosition(1);
setFontSizeAbsolute(getO1Label(),true);
setFontSizeInPoints(getO1Label(),10);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeInPoints(getY1Label(),10);
setDisplay(getDataText(),false);
setPlaceResize(getDataText(),0);
setFontSizeAbsolute(getLegendText(),true);
setFontSizeInPoints(getLegendText(),10);
setTextString(getTitle(),"Heinz");
setDisplay(getTitle(),true);
setPlaceResize(getTitle(),0);
setFillColor(getTitle(),new Color(0,0,0));
setFontSizeAbsolute(getTitle(),true);
setFontSizeInPoints(getTitle(),9);
setTextString(getSubtitle(),"Key Milestones");
setDisplay(getSubtitle(),true);
setPlaceResize(getSubtitle(),0);
setFillColor(getSubtitle(),new Color(170,70,67));
setFontName(getSubtitle(),"Arial");
setFontSizeAbsolute(getSubtitle(),true);
setFontSizeInPoints(getSubtitle(),12);
setFontStyle(getSubtitle(),0);
setTextString(getFootnote(),"&START_DATE1 thru &END_DATE1");
setDisplay(getFootnote(),true);
setPlaceResize(getFootnote(),0);
setPlaceAlign(getFootnote(),0);
setFontName(getFootnote(),"Arial");
setFontStyle(getFootnote(),0);
setFontSizeAbsolute(getFootnote(),true);
setFontSizeInPoints(getFootnote(),7);
setFontSizeAbsolute(getDataText(),true);
setFontSizeInPoints(getDataText(),8);
setFillColor(getDataText(),new Color(255,255,255));
setDataTextPosition(3);
setFillColor(getSeries(0),new Color(136,165,78));
setTextJustHoriz(getFootnote(),1);
setBorderColor(getSeries(0),new Color(0,0,0));
setBorderColor(getSeries(1),new Color(0,0,0));
ENDSTYLE
END


I used Dan Satchell's suggestion. It was the only thing that worked for me. Thank you!

This message has been edited. Last edited by: Leo Sanchez,

Depending on the number of distinct values in SHIPMENT_MSR, one trick you can use is to put spaces in front of the values to get them to sort the way you want. For example:

DEFINE FILE CAR
 SORTIR/A25 = IF (COUNTRY EQ 'FRANCE')      THEN ('     ' | CAR) ELSE
              IF (COUNTRY EQ 'ITALY')       THEN ('    '  | CAR) ELSE
              IF (COUNTRY EQ 'JAPAN')       THEN ('   '   | CAR) ELSE
              IF (COUNTRY LIKE '%GERMANY%') THEN ('  '    | CAR) ELSE 
              IF (COUNTRY NE 'ENGLAND')     THEN (' '     | CAR) ELSE CAR ;
END
-*
TABLE FILE CAR
 PRINT COUNTRY
 BY SORTIR
END

Use the COLUMNS and/or ROWS statements
GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
COLUMNS FRANCE JAPAN ITALY ENGLAND BURKINAFASO
END
..i can't remember whether its columns or rows in this example but you get my drift.
i use this in all my graphs for sales by size
b/c my sizes are XS,S,M,L,XL

...and i just wanted to write BURKINAFASO somewhere today

It is columns:

GRAPH FILE CAR
SUM SALES
ACROSS COUNTRY
COLUMNS FRANCE AND JAPAN AND ITALY AND ENGLAND AND 'S. AFRICA'
END

oh right, the 'AND's...critical
muchas ta