HI

IN BAR GRAPHS WHEN I’M DOING ACROSS-TOTAL NAME AS

ACROSS-TOTAL AS 'TOT_DISP'

THAT TOTAL NAME(TOT_DISP) IS NOT DISPLAYING IN BAR GRAPHS

PLEASE ANY ONE GIVE ME GUIDANCE

THANKS

This message has been edited. Last edited by: Kerry,

Can you post an example with one of the sample files ?

Hi Deepu,

I checked with our graph expert and was suggested that, it is not easy to reproduce the issue, so please open a case with Customer Support Services for further research. You may either call at 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry

quote:

Originally posted by Waz:
Can you post an example with one of the sample files ?

i need across total name as "TOTAL_FLD" in bar graph

GRAPH FILE CAR
-* Created by Advanced Graph Assistant
SUM DEALER_COST
BY SEATS
ACROSS COUNTRY
ACROSS-TOTAL AS 'TOTAL_FLD'
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 450
ON GRAPH SET VAXIS 350
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setDepthRadius(0);
setDepthAngle(0);
setDisplay(getO1MajorGrid(),false);
setFontSizeAbsolute(getLegendText(),true);
setFontSizeInPoints(getLegendText(),9);
setPlaceResize(getLegendText(),0);
setFontSizeAbsolute(getO1Label(),true);
setFontSizeInPoints(getO1Label(),9);
setPlaceResize(getO1Label(),0);
setTextRotation(getO1Label(),1);
setTextString(getY1Title(),"");
setFontSizeAbsolute(getO1Title(),true);
setFontSizeInPoints(getO1Title(),9);
setPlaceResize(getO1Title(),0);
setGridStepAuto(getY1MajorGrid(),true);
setPlaceAlign(getTitle(),0);
setFontSizeAbsolute(getTitle(),true);
setFontSizeInPoints(getTitle(),10);
setPlaceResize(getTitle(),0);
setTextJustHoriz(getTitle(),0);
setFillColor(getSeries(4),new Color(75,172,198));
setFillColor(getSeries(3),new Color(127,100,162));
setFillColor(getSeries(2),new Color(155,187,89));
setFillColor(getSeries(1),new Color(192,80,77));
setFillColor(getSeries(0),new Color(78,129,189));
setReverseGroups(false);
setDisplay(getO1AltFmtFrame(),false);
setPlaceAlign(getO1Label(),1);
setReverseSeries(true);
ENDSTYLE
END


This acorss total(TOTAL_FLD)name not displaying in Graph, when i used AS 'TOTAL_FLD'

This is code for ouput report

TABLE FILE CAR
SUM DEALER_COST
BY SEATS
ACROSS COUNTRY
ACROSS-TOTAL AS 'TOTAL_FLD'
END

can any one help me plz

This message has been edited. Last edited by: Deepu,

Best I can come up with, not GUI compliant! Maybe someone else will have an idea...

  
-SET &ECHO=ALL;
SET ASNAMES = ON
TABLE FILE CAR
SUM DEALER_COST
BY SEATS
BY COUNTRY
  ON TABLE HOLD AS HOLD1
END
-RUN
DEFINE FILE CAR
 XCOUNTRY/A10 = '* Total';
END
TABLE FILE CAR
SUM DEALER_COST
BY SEATS
BY XCOUNTRY AS 'COUNTRY'
  ON TABLE HOLD AS HOLD2
END
-RUN

TABLE FILE HOLD1
SUM DEALER_COST
BY SEATS
BY COUNTRY
  ON TABLE HOLD AS HOLD3 FORMAT ALPHA
MORE
FILE HOLD2
END
-RUN
TABLE FILE HOLD3 
BY COUNTRY
 ON TABLE SAVE AS XHOLD
END
-RUN
-SET &COL1 = '';
-SET &XLINES = &LINES;
-SET &CNTR = 0;
-REPEAT GET_COUNTRY &XLINES TIMES
-SET &CNTR = &CNTR + 1;
-READ XHOLD &XCOL.A10.
-SET &COL.&CNTR = &XCOL;
-GET_COUNTRY

GRAPH FILE HOLD3
-* Created by Advanced Graph Assistant
SUM DEALER_COST
BY SEATS
ACROSS COUNTRY COLUMNS 
-SET &XCNTR = &XLINES - 1;
-SET &NEW_CNTR = 1;
-REPEAT DO_COLS &XCNTR TIMES
-SET &NEW_CNTR = &NEW_CNTR + 1;
-SET &SHOW_COLS = '&' || 'COL' || &NEW_CNTR;
  '&SHOW_COLS.EVAL' AND
-DO_COLS
  '&COL1.EVAL'
-*ACROSS-TOTAL AS 'TOTAL_FLD'
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 450
ON GRAPH SET VAXIS 350
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRMERGE ON
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setDepthRadius(0);
setDepthAngle(0);
setDisplay(getO1MajorGrid(),false);
setFontSizeAbsolute(getLegendText(),true);
setFontSizeInPoints(getLegendText(),9);
setPlaceResize(getLegendText(),0);
setFontSizeAbsolute(getO1Label(),true);
setFontSizeInPoints(getO1Label(),9);
setPlaceResize(getO1Label(),0);
setTextRotation(getO1Label(),1);
setTextString(getY1Title(),"");
setFontSizeAbsolute(getO1Title(),true);
setFontSizeInPoints(getO1Title(),9);
setPlaceResize(getO1Title(),0);
setGridStepAuto(getY1MajorGrid(),true);
setPlaceAlign(getTitle(),0);
setFontSizeAbsolute(getTitle(),true);
setFontSizeInPoints(getTitle(),10);
setPlaceResize(getTitle(),0);
setTextJustHoriz(getTitle(),0);
setFillColor(getSeries(4),new Color(75,172,198));
setFillColor(getSeries(3),new Color(127,100,162));
setFillColor(getSeries(2),new Color(155,187,89));
setFillColor(getSeries(1),new Color(192,80,77));
setFillColor(getSeries(0),new Color(78,129,189));
setReverseGroups(false);
setDisplay(getO1AltFmtFrame(),false);
setPlaceAlign(getO1Label(),1);
setReverseSeries(true);
ENDSTYLE
END
-EXIT

quote:

Tom Flynn

Hi Tom Flynn

Thanks its working fine