Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     graph in individual sheets in Excel report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
graph in individual sheets in Excel report
 Login/Join
 
Member
posted
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
 
Posts: 11 | Location: Florida | Registered: December 08, 2011Report This Post
Virtuoso
posted Hide Post
Taka a look at
This
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Gold member
posted Hide Post
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.


WF 7.6.10, Windows, PDF, Excel
 
Posts: 75 | Location: Dallas, TX | Registered: February 12, 2004Report This Post
Member
posted Hide Post
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
 
Posts: 11 | Location: Florida | Registered: December 08, 2011Report This Post
Expert
posted Hide Post
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. Cool




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Expert
posted Hide Post
BTW: Can you duplicate the using the CAR file?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Member
posted Hide Post
Thanks 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
 
Posts: 11 | Location: Florida | Registered: December 08, 2011Report This Post
Master
posted Hide Post
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?


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Member
posted Hide Post
from earlier suggestion of exl2k not liking sqlout


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 11 | Location: Florida | Registered: December 08, 2011Report This Post
Member
posted Hide Post
Is there a default location where the graph image file is stored.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 11 | Location: Florida | Registered: December 08, 2011Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     graph in individual sheets in Excel report

Copyright © 1996-2020 Information Builders