Focal Point
graph in individual sheets in Excel report
August 06, 2012, 11:28 AM
NCFSchlinzgraph in individual sheets in Excel report
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
WebFOCUS 7.6
Windows, All Outputs
August 07, 2012, 09:17 AM
PrarieTaka a look at
ThisAugust 13, 2012, 01:19 PM
Mary WatermannI 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.
WF 7.6.10, Windows, PDF, Excel
August 16, 2012, 04:49 PM
NCFSchlinzstill 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
August 16, 2012, 05:25 PM
Doug1st 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.
| In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |
August 16, 2012, 05:28 PM
DougBTW: Can you duplicate the using the CAR file?
August 17, 2012, 08:19 AM
NCFSchlinzThanks for your help. Do you mean duplicate what I am trying to do with SQLOUT with the CAR file?
WebFOCUS 7.6
Windows, All Outputs
August 17, 2012, 10:31 AM
PBrightwellquote:
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?
Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
August 17, 2012, 01:23 PM
NCFSchlinzfrom earlier suggestion of exl2k not liking sqlout
WebFOCUS 7.6
Windows, All Outputs
August 17, 2012, 05:03 PM
NCFSchlinzIs there a default location where the graph image file is stored.
WebFOCUS 7.6
Windows, All Outputs