Graph in Report not showing for me but does for co-worker SOLVED

November 06, 2013, 11:06 AM

I checked all settings and not only was my graphs not showing, my screen was split and number of records was showing below my table. In a post on this site it told how to turn that off. Go to Edit in Text Editor and you will see a drop down arrow next to the run icon. Turn Messages Off. I can now see the graphs and the screen is no longer split.

I needed a report with top 5 referrals, amount for the Fiscal Year (Oct to last day of prior month), percent difference between last and current Fiscal Year. Then beside that I need two graphs, one showing the last 8 years and then a month to month comparison (not in code yet).
The code below was to get it going (I'm a beginner learning along the way) and I'll refactor with loops, get rid of the last 8 columns and just have the graph, etc.
PROBLEM: When I run the file I get the table only and not the graph. When my co-worker runs the exact same file, he gets the table and then the graph underneath. We are using the same version, I checked the properties and environments and they are the same. I cleared my cache.
I can run the graph by itself and it shows.
This stops me dead in the water if my graphs won't show.
UPDATE: When I Edit in Developer Studio and switch the Hold Report and Hold Graph's positions, then I get the Graph but then not the table. Like it stops before executing the last Hold.

-*--Allocate agency abbreviation file
FILEDEF AGYABBRV DISK apid/agency_abbrev.txt (APPEND

-*--Add Define field to Collection Referrral MQT table
-*--Decode AGYABBREV field using AGYABBRV file
DEFINE FILE REFERRAL ADD
AGYABBREV/A10V=DECODE A_CODE( AGYABBRV ELSE ERR );
END

-*-- Beginning of Fiscal Year Function

DEFINE FUNCTION BOCFY(INDATE/A8)
INDTYYA/A4 = EDIT(INDATE,'9999$$$$');
INDTYY/I4 = EDIT(INDTYYA);
INDTMM/A2 = EDIT(INDATE,'$$$$99$$');
OUTDTYY/I4 = IF INDTMM LT '11' THEN INDTYY - 1 ELSE INDTYY;
BOCFY/A8 = EDIT(OUTDTYY) || '1001';
END
-RUN
-SET &ECHO=ON;
-SET &BEGIN_FY1 = '20121001';
-*SET &BEGIN_FY1 = BOCFY(&YYMD);
-SET &END_FY1 = DATECVT(DATEADD((DATEADD((DATECVT(&BEGIN_FY1,'I8YYMD','YYMD')),'M', +12)),'D', -1),'YYMD','I8YYMD');
-SET &BEGIN_FY2 = DATECVT((DATEADD((DATECVT(&BEGIN_FY1,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &END_FY2 = DATECVT((DATEADD((DATECVT(&BEGIN_FY1,'I8YYMD','YYMD')),'D', -1)),'YYMD','I8YYMD');
-SET &TODAY = '20121105';
-*SET &TODAY = EDIT(&DATEYYMD, '9999$99$99');
-SET &BEGIN_MONTH = DATECVT((DATEMOV((DATECVT(&TODAY,'I8YYMD','YYMD')),'BOM')),'YYMD','I8YYMD');
-SET &PREV_WORK_DATE = DATECVT((DATEMOV((DATECVT(&BEGIN_MONTH,'I8YYMD','YYMD')),'PWD')),'YYMD','I8YYMD');
-SET &PREV_EOM_FY1 = DATECVT((DATEMOV((DATECVT(&PREV_WORK_DATE,'I8YYMD','YYMD')),'EOM')),'YYMD','I8YYMD');
-SET &PREV_EOM_FY2 = DATECVT((DATEADD((DATECVT(&PREV_EOM_FY1,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &BEGIN_FY3 = DATECVT((DATEADD((DATECVT(&BEGIN_FY2,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &PREV_EOM_FY3 = DATECVT((DATEADD((DATECVT(&PREV_EOM_FY2,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &BEGIN_FY4 = DATECVT((DATEADD((DATECVT(&BEGIN_FY3,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &PREV_EOM_FY4 = DATECVT((DATEADD((DATECVT(&PREV_EOM_FY3,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &BEGIN_FY5 = DATECVT((DATEADD((DATECVT(&BEGIN_FY4,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &PREV_EOM_FY5 = DATECVT((DATEADD((DATECVT(&PREV_EOM_FY4,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &BEGIN_FY6 = DATECVT((DATEADD((DATECVT(&BEGIN_FY5,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &PREV_EOM_FY6 = DATECVT((DATEADD((DATECVT(&PREV_EOM_FY5,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &BEGIN_FY7 = DATECVT((DATEADD((DATECVT(&BEGIN_FY6,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &PREV_EOM_FY7 = DATECVT((DATEADD((DATECVT(&PREV_EOM_FY6,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &BEGIN_FY8 = DATECVT((DATEADD((DATECVT(&BEGIN_FY7,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');
-SET &PREV_EOM_FY8 = DATECVT((DATEADD((DATECVT(&PREV_EOM_FY7,'I8YYMD','YYMD')),'M', -12)),'YYMD','I8YYMD');

-*Get TOP 5 and Amount for this FYTD
TABLE FILE REFERRAL
SUM 'REFERRAL.REFERRAL.AMOUNT/P16CM' AS FYTD
BY TOTAL HIGHEST 5 'REFERRAL.REFERRAL.AMOUNT'
BY 'REFERRAL.REFERRAL.A_CODE' NOPRINT
BY AGYABBREV AS ''
WHERE ( PAYMENT_EFFECTIVE_DATE GE &BEGIN_FY1 ) AND ( PAYMENT_EFFECTIVE_DATE LE &PREV_EOM_FY1 )
ON TABLE HOLD AS FYTDHT FORMAT FOCUS
END

TABLE FILE REFERRAL
SUM 'REFERRAL.REFERRAL.AMOUNT/P16CM' AS PFYTD
BY TOTAL HIGHEST 50 'REFERRAL.REFERRAL.AMOUNT'
BY 'REFERRAL.REFERRAL.A_CODE' NOPRINT
BY AGYABBREV AS ''
WHERE ( PAYMENT_EFFECTIVE_DATE GE &BEGIN_FY2 ) AND ( PAYMENT_EFFECTIVE_DATE LE &PREV_EOM_FY2 )
ON TABLE HOLD AS PYVCYHT FORMAT FOCUS
END

TABLE FILE REFERRAL
SUM 'REFERRAL.REFERRAL.AMOUNT/P16CM' AS FYA1
BY TOTAL HIGHEST 5 'REFERRAL.REFERRAL.AMOUNT'
BY 'REFERRAL.REFERRAL.A_CODE' NOPRINT
BY AGYABBREV AS ''
WHERE ( PAYMENT_EFFECTIVE_DATE GE &BEGIN_FY1 ) AND ( PAYMENT_EFFECTIVE_DATE LE &PREV_EOM_FY1 )
ON TABLE HOLD AS FY1 FORMAT FOCUS
END

TABLE FILE REFERRAL
SUM 'REFERRAL.REFERRAL.AMOUNT/P16CM' AS FYA2
BY 'REFERRAL.REFERRAL.A_CODE' NOPRINT
BY AGYABBREV AS ''
WHERE ( PAYMENT_EFFECTIVE_DATE GE &BEGIN_FY2 ) AND ( PAYMENT_EFFECTIVE_DATE LE &PREV_EOM_FY2 )
ON TABLE HOLD AS FY2 FORMAT FOCUS
END

TABLE FILE REFERRAL
SUM 'REFERRAL.REFERRAL.AMOUNT/P16CM' AS FYA3
BY 'REFERRAL.REFERRAL.A_CODE' NOPRINT
BY AGYABBREV AS ''
WHERE ( PAYMENT_EFFECTIVE_DATE GE &BEGIN_FY3 ) AND ( PAYMENT_EFFECTIVE_DATE LE &PREV_EOM_FY3 )
ON TABLE HOLD AS FY3 FORMAT FOCUS
END

TABLE FILE REFERRAL
SUM 'REFERRAL.REFERRAL.AMOUNT/P16CM' AS FYA4
BY 'REFERRAL.REFERRAL.A_CODE' NOPRINT
BY AGYABBREV AS ''
WHERE ( PAYMENT_EFFECTIVE_DATE GE &BEGIN_FY4 ) AND ( PAYMENT_EFFECTIVE_DATE LE &PREV_EOM_FY4 )
ON TABLE HOLD AS FY4 FORMAT FOCUS
END

TABLE FILE REFERRAL
SUM 'REFERRAL.REFERRAL.AMOUNT/P16CM' AS FYA5
BY 'REFERRAL.REFERRAL.A_CODE' NOPRINT
BY AGYABBREV AS ''
WHERE ( PAYMENT_EFFECTIVE_DATE GE &BEGIN_FY5 ) AND ( PAYMENT_EFFECTIVE_DATE LE &PREV_EOM_FY5 )
ON TABLE HOLD AS FY5 FORMAT FOCUS
END
-*LINE 100
TABLE FILE REFERRAL
SUM 'REFERRAL.REFERRAL.AMOUNT/P16CM' AS FYA6
BY 'REFERRAL.REFERRAL.A_CODE' NOPRINT
BY AGYABBREV AS ''
WHERE ( PAYMENT_EFFECTIVE_DATE GE &BEGIN_FY6 ) AND ( PAYMENT_EFFECTIVE_DATE LE &PREV_EOM_FY6 )
ON TABLE HOLD AS FY6 FORMAT FOCUS
END

TABLE FILE REFERRAL
SUM 'REFERRAL.REFERRAL.AMOUNT/P16CM' AS FYA7
BY 'REFERRAL.REFERRAL.A_CODE' NOPRINT
BY AGYABBREV AS ''
WHERE ( PAYMENT_EFFECTIVE_DATE GE &BEGIN_FY7 ) AND ( PAYMENT_EFFECTIVE_DATE LE &PREV_EOM_FY7 )
ON TABLE HOLD AS FY7 FORMAT FOCUS
END

TABLE FILE REFERRAL
SUM 'REFERRAL.REFERRAL.AMOUNT/P16CM' AS FYA8
BY 'REFERRAL.REFERRAL.A_CODE' NOPRINT
BY AGYABBREV AS ''
WHERE ( PAYMENT_EFFECTIVE_DATE GE &BEGIN_FY8 ) AND ( PAYMENT_EFFECTIVE_DATE LE &PREV_EOM_FY8 )
ON TABLE HOLD AS FY8 FORMAT FOCUS
END

MATCH FILE FYTDHT
PRINT
FYTD
BY AGYABBREV
RUN
FILE PYVCYHT
PRINT
PFYTD
BY AGYABBREV
AFTER MATCH HOLD OLD
RUN
FILE FY1
PRINT
FYA1
BY AGYABBREV
RUN
FILE FY2
PRINT
FYA2
BY AGYABBREV
AFTER MATCH HOLD OLD
RUN
FILE FY3
PRINT
FYA3
BY AGYABBREV
AFTER MATCH HOLD OLD
RUN
FILE FY4
PRINT
FYA4
BY AGYABBREV
AFTER MATCH HOLD OLD
RUN
FILE FY5
PRINT
FYA5
BY AGYABBREV
AFTER MATCH HOLD OLD
RUN
FILE FY6
PRINT
FYA6
BY AGYABBREV
AFTER MATCH HOLD OLD
RUN
FILE FY7
PRINT
FYA7
BY AGYABBREV
AFTER MATCH HOLD OLD
RUN
FILE FY8
PRINT
FYA8
BY AGYABBREV
AFTER MATCH HOLD OLD
END
-RUN

TABLE FILE HOLD
SUM
COMPUTE PERCENT/D12.2% = (PFYTD - FYTD)* 100 / FYTD; NOPRINT
BY HIGHEST FYTD NOPRINT
PRINT
'AGYABBREV' AS 'AGENCY'
'FYTD'
'PERCENT' AS 'PYvCY FYTD'
'FYA8'
'FYA7'
'FYA6'
'FYA5'
'FYA4'
'FYA3'
'FYA2'
'FYA1'
END

GRAPH FILE HOLD
SUM HOLD.HOLD.FYA1 HOLD.HOLD.FYA2 HOLD.HOLD.FYA3 HOLD.HOLD.FYA4 HOLD.HOLD.FYA5 HOLD.HOLD.FYA6 HOLD.HOLD.FYA7 HOLD.HOLD.FYA8
ACROSS HOLD.HOLD.AGYABBREV
BY HOLD.HOLD.AGYABBREV
HEADING
"ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRWIDTH 1
ON GRAPH PCHOLD FORMAT GIF
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setAxisAssignment(1,0);
setAxisAssignment(2,0);
setAxisAssignment(3,0);
setAxisAssignment(4,0);
setAxisAssignment(5,0);
setAxisAssignment(6,0);
setAxisAssignment(7,0);
setSeriesType(7,1);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLOR='BLACK',
$
ENDSTYLE
END

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