I am displaying "Percentage" sales across different "Category".
I want to sort the "Category" in a particular way in the graph (i have created the field on which i want to sort, through my define clause).

Now the question is how to use the new field RANKSORT in the GRAPH FILE statement to do the sorting.

I tried giving it as a NOPRINT in GHRAPH FILE statement, but its not working.

any clue how to use it ??

tks/sam

WF Server: 7.1.4 on Z/OS and Linux, ReportCaster
Data: DB2, DB2/UDB, Adabas, SQL Server, Oracle Output: HTML,PDF,Excel2K
WF Client: Servlet, CGI

Hi,

I had the same problem few weeks ago and one of the hotline-people sent me this solution:

GRAPH FILE filename
SUM field

-* the real sortfield (invisible)
BY byField1

the sortfield for display
BY byfield2

...

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 LOOKGRAPH VLINE
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 708
ON GRAPH SET HAXIS 1617
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
HAUTO=OFF

setO1AxisSide(0);
setMarkerDisplay(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(1);
setO1MinorGridDisplay(true);
setO1MinorGridStyle(0);
setAxisAssignment(0,0);
setSeriesType(0,2);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setReverseGroups(true);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getTitle(),true);
setFontSizeAbsolute(getLegendText(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setTextJustHoriz(getO1Title(),1);
setFontSizeAbsolute(getO1Title(),true);
setFontSize(getO1Title(),12);
setTextRotation(getO1Title(),0);
setTextWrap(getO1Title(),false);

-* !!!
setTextJustHoriz(getO1Label(),0);
setTextRotation(getO1Label(),2);

setFontSizeAbsolute(getO1Label(),true);
setFontSize(getO1Label(),12);
setTextWrap(getO1Label(),false);
setPlaceResize(getO1Title(),0);
setPlaceRotate(getO1Title(),0);
setPlaceAlign(getO1Title(),0);
setPlaceWordWrap(getO1Title(),0);
setPlaceResize(getO1Label(),0);
setPlaceRotate(getO1Label(),0);
setPlaceAlign(getO1Label(),0);
setPlaceWordWrap(getO1Label(),0);
setPlace(true);

-* switch the line for double x-axis off
setDisplay(getNestedO1LabelLine(),false);

-* replace the text to blank
setNestedO1Label(getNestedO1Level(1,0)," ");
setNestedO1Label(getNestedO1Level(1,1)," ");
setNestedO1Label(getNestedO1Level(1,2)," ");
setNestedO1Label(getNestedO1Level(1,3)," ");
setNestedO1Label(getNestedO1Level(1,4)," ");
setNestedO1Label(getNestedO1Level(1,5)," ");
setNestedO1Label(getNestedO1Level(1,6)," ");
setNestedO1Label(getNestedO1Level(1,7)," ");
setNestedO1Label(getNestedO1Level(1,8)," ");
setNestedO1Label(getNestedO1Level(1,9)," ");
setNestedO1Label(getNestedO1Level(1,10)," ");
setNestedO1Label(getNestedO1Level(1,11)," ");
setNestedO1Label(getNestedO1Level(1,12)," ");
setNestedO1Label(getNestedO1Level(1,13)," ");
setNestedO1Label(getNestedO1Level(1,14)," ");
setNestedO1Label(getNestedO1Level(1,15)," ");
setNestedO1Label(getNestedO1Level(1,16)," ");

Sam,

I have posted a solution to this several times on this forum. My solution uses Dialogue Manager. Please do a search on my name to find my posts regarding this.