Hello,

I am trying to get my graph to display in my tabbed excel report. Not having any luck. View the posting in the forum but still having trouble. Any help will be greatly appreciated. The following is my report.

ENGINE SQLORA SET DEFAULT_CONNECTION NCPO
SQL SQLORA PREPARE SQLOUT FOR
select A.SSBSECT_TERM_CODE term_cd, A.SSBSECT_CRN CRN, a.ssbsect_seq_numb seq,
acadmgr.f_course_instructor (b.crn, b.term) instructor,
A.SSBSECT_SUBJ_CODE subj, a.ssbsect_crse_numb CRS_NBR, C.TITLE long_title,
C.DIVS_DESC, C.DEPT_DESC,
sum(requests) requests,
max(ssbsect_enrl) registered,
sum(requests) - max(ssbsect_enrl) variance
from ssbsect a, acadmgr.crs_unmet_demand_v b, acadmgr.cre_section_base_info c
where a.ssbsect_crn = b.crn
and a.ssbsect_term_code = b.term
and a.ssbsect_crn = c.crn
and a.ssbsect_term_code = c.term_code
and a.ssbsect_schd_code in ('B','C','L')
and ssbsect_ssts_code = 'A'
group by A.SSBSECT_SUBJ_CODE, a.ssbsect_crse_numb, C.DIVS_DESC, C.DEPT_DESC,
A.SSBSECT_CRN, a.ssbsect_seq_numb, A.SSBSECT_TERM_CODE,
C.TITLE, acadmgr.f_course_instructor (b.crn, b.term)
order by A.SSBSECT_SUBJ_CODE, a.ssbsect_crse_numb, a.ssbsect_seq_numb, A.SSBSECT_TERM_CODE;
END
SET SUMMARYLINES=NEW
SET EMPTYREPORT=ON
TABLE FILE SQLOUT
PRINT
LONG_TITLE AS "COURSE"
TERM_CD AS "TERM"
CRN
SEQ
INSTRUCTOR
SUBJ
CRS_NBR
DIVS_DESC
DEPT_DESC
REQUESTS
REGISTERED
VARIANCE
BY DEPT_DESC
BY LONG_TITLE NOPRINT
ON LONG_TITLE SUBTOTAL
AVE. REQUESTS
AVE. REGISTERED
AVE. VARIANCE AS '*AVERAGE '
HEADING
"New College of Florida Course Request System Historical Metrics as of <+0>&DATEtrMDYY <+0> "
" "
FOOTING
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK
ON TABLE SET COMPOUND 'BYTOC 1'
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
LEFTGAP=0.000000,
LINES-PER-PAGE=80,
$
TYPE=DATA,
COLUMN=N13,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N12,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N11,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N10,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N9,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N7,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N6,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N4,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N3,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N2,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N5,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N8,
JUSTIFY=CENTER,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N13,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N12,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N11,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N10,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N9,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N7,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N6,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N4,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N3,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N2,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N5,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N8,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=OFF,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=OFF,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=6.000000,
$
ENDSTYLE
END
GRAPH FILE SQLOUT
SUM REGISTERED
ACROSS REQUESTS
ON GRAPH SET LOOKGRAPH SCATTERS
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID OFF
ON GRAPH PCHOLD FORMAT JPEG
ON GRAPH PCHOLD FORMAT EXL2K CLOSE
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setX1LabelDisplay(true);
setX1AxisSide(0);
setX1MajorGridDisplay(true);
setX1MajorGridStyle(0);
setX1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getX1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END

Taka a look at
This

I see you are doing your whole report from SQLOUT.

I have found TABLE FILE SQLOUT does not like going to Excel.

Try just doing a HOLD AS holdname after the SQLOUT then doing your report from that hold file.

Just a thought.

still struggling with this.

Here is the error message I am currently getting:

0 NUMBER OF RECORDS IN GRAPH= 1072 PLOT POINTS= 75
(FOC3230) HTTP REQUEST FOR GRAPHSERVURL RETURNED ERROR: ???
GIF FILE SAVED ...
0 ERROR AT OR NEAR LINE 83 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC002) A WORD IS NOT RECOGNIZED: TABLE
(FOC009) INCOMPLETE REQUEST STATEMENT
(FOC3298) ERROR FOUND IN A COMPOUND REPORT
Compound Report is TERMINATING.....
BYPASSING TO END OF COMMAND



Here is my current code:

ENGINE SQLORA SET DEFAULT_CONNECTION NCPO
SQL SQLORA PREPARE SQLOUT FOR
select A.SSBSECT_TERM_CODE term_cd, A.SSBSECT_CRN CRN, a.ssbsect_seq_numb seq,
acadmgr.f_course_instructor (b.crn, b.term) instructor,
A.SSBSECT_SUBJ_CODE subj, a.ssbsect_crse_numb CRS_NBR, C.TITLE long_title,
C.DIVS_DESC, C.DEPT_DESC,
sum(requests) req,
max(ssbsect_enrl) reg,
sum(requests) - max(ssbsect_enrl) variance
from ssbsect a, acadmgr.crs_unmet_demand_v b, acadmgr.cre_section_base_info c
where a.ssbsect_crn = b.crn
and a.ssbsect_term_code = b.term
and a.ssbsect_crn = c.crn
and a.ssbsect_term_code = c.term_code
and a.ssbsect_schd_code in ('B','C','L')
and ssbsect_ssts_code = 'A'
group by A.SSBSECT_SUBJ_CODE, a.ssbsect_crse_numb, C.DIVS_DESC, C.DEPT_DESC,
A.SSBSECT_CRN, a.ssbsect_seq_numb, A.SSBSECT_TERM_CODE,
C.TITLE, acadmgr.f_course_instructor (b.crn, b.term)
order by A.SSBSECT_SUBJ_CODE, a.ssbsect_crse_numb, a.ssbsect_seq_numb, A.SSBSECT_TERM_CODE;

END

-*SET GMERGE = ON
GRAPH FILE SQLOUT
SUM REG
ACROSS REQ
ON GRAPH SET LOOKGRAPH SCATTERS
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 HOLD AS CRSGRAPH1 FORMAT GIF
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setX1LabelDisplay(true);
setX1AxisSide(0);
setX1MajorGridDisplay(true);
setX1MajorGridStyle(0);
setX1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,0);
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(getX1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END

SET EMPTYREPORT=ON
SET COMPOUND='OPEN NOBREAK'
TABLE FILE SQLOUT
ON TABLE HOLD AS CRSOUT FORMAT EXL2K
TABLE FILE CRSOUT
PRINT
LONG_TITLE AS "COURSE"
TERM_CD AS "TERM"
CRN
SEQ
INSTRUCTOR
SUBJ
CRS_NBR
DIVS_DESC
DEPT_DESC
REQ
REG
VARIANCE
BY LONG_TITLE NOPRINT
HEADING
"New College of Florida Course Request System Historical Metrics as of <+0>&DATEtrMDYY <+0> "
" "
FOOTING
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
-*WHERE RECORDLIMIT EQ 1
-* TABLE PCHOLD FORMAT EXL2K
ON TABLE SET COMPOUND 'BYTOC 1'
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
LEFTGAP=0.000000,
TITLETEXT='All Courses',
LINES-PER-PAGE=80,
-* IMAGE=CRSGRAPH1.gif, POSITION=(4.5 0.5)
$
TYPE=DATA,
COLUMN=N13,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N12,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N11,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N10,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N9,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N7,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N6,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N4,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N3,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N2,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N5,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N8,
JUSTIFY=CENTER,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N13,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N12,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N11,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N10,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N9,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N7,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N6,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N4,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N3,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N2,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N5,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N8,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=OFF,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=OFF,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=6.000000,
$
ENDSTYLE
END

GRAPH FILE SQLOUT
SUM REG
ACROSS REQ
BY LONG_TITLE
HEADING
"ON GRAPH SET LOOKGRAPH SCATTERS
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
-*SET APPLET SIZING=ON
ON GRAPH SET VAXIS 691
ON GRAPH SET HAXIS 1232
ON GRAPH SET GRWIDTH 0
ON GRAPH HOLD AS CRSGRAPH2 FORMAT GIF
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setX1LabelDisplay(true);
setX1AxisSide(0);
setX1MajorGridDisplay(true);
setX1MajorGridStyle(0);
setX1MinorGridDisplay(false);
setAxisAssignment(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getX1Title(),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

SET COMPOUND=CLOSE
TABLE FILE SQLOUT
ON TABLE HOLD AS CRSOUT FORMAT EXL2K
TABLE FILE CRSOUT
PRINT
LONG_TITLE AS "COURSE"
TERM_CD AS "TERM"
INSTRUCTOR
REQ
REG
VARIANCE
BY DEPT_DESC NOPRINT
BY LONG_TITLE NOPRINT
ON LONG_TITLE SUBTOTAL
AVE. REQ
AVE. REG
AVE. VARIANCE AS '*AVERAGE '
HEADING
"New College of Florida Course Request System Historical Metrics as of <+0>&DATEtrMDYY <+0> "
" "
FOOTING
" "
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
-*TABLE PCHOLD FORMAT EXL2K
ON TABLE SET COMPOUND 'BYTOC 1' NOBREAK
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
LEFTGAP=0.000000,
LINES-PER-PAGE=80,
-*IMAGE=CRSGRAPH2.gif, POSITION=(4 6)
TYPE=DATA,
COLUMN=N13,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N12,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N11,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N10,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N9,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N7,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N6,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N4,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N3,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N2,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N5,
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N8,
JUSTIFY=CENTER,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N13,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N12,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N11,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N10,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N9,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N7,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N6,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N4,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N3,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N2,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N5,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N8,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=OFF,
$
TYPE=REPORT,
COLUMN=N8,
SQUEEZE=OFF,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=6.000000,
$
ENDSTYLE
END

WebFOCUS 7.6
Windows, All Outputs

1st error, in line 83, as indicated:

...
TABLE FILE SQLOUT
ON TABLE HOLD AS CRSOUT FORMAT EXL2K
TABLE FILE CRSOUT
...

Where the rest of that 1st TABLE FILE request? No verbs, END, etc... And, just like a COBOL listing: stop looking at the rest of the errors until the 1st one is resolved.

BTW: Can you duplicate the using the CAR file?

Thanks for your help. Do you mean duplicate what I am trying to do with SQLOUT with the CAR file?

quote:

TABLE FILE SQLOUT
ON TABLE HOLD AS CRSOUT FORMAT EXL2K
TABLE FILE CRSOUT

As Doug pointed out, you don't have an END statement between the two TABLE statements which would give you the error that you are getting. I don't think you would have anything in CRSOUT without a PRINT *, but why would you hold a file as format EXL2K if you are going to reuse it?

from earlier suggestion of exl2k not liking sqlout

Is there a default location where the graph image file is stored.