Focal Point
error-UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4981031252

October 16, 2007, 10:02 AM
vkrugman
error-UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE
Please help! Keep getting this 0 NUMBER OF RECORDS IN TABLE= 4 LINES= 1
0 NUMBER OF RECORDS IN TABLE= 403916 LINES= 1
0 NUMBER OF RECORDS IN TABLE= 1293 LINES= 156
(BEFORE TOTAL TESTS)
0 NUMBER OF RECORDS IN TABLE= 4 LINES= 4
0 NUMBER OF RECORDS IN TABLE= 4 LINES= 1
0 NUMBER OF RECORDS IN TABLE= 444 LINES= 3
0 NUMBER OF RECORDS IN TABLE= 3 LINES= 1
(FOC3209) UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE: 2 SET PCHOLD-FMT
RUNTIME: 00:00:33
This line gets generated every time in my program after I delete it. When I run my procedure from WF Developer Studio, it works, BUT WHen I delete this line and run it from our application server that error keeps comming back! Please advise!


Valeriya

WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000
October 16, 2007, 10:11 AM
Leah
Without knowing what version you are using it makes it difficult to help, can you post the segment of code giving the error. It appears you may be deleting something else which shows the start of the styling.


Leah
October 16, 2007, 10:21 AM
vkrugman
this line SET PCHOLD-FMT=BINARY :

COMPUTE
IX/P5.2=C4T3/C4T4; AS '' IN 101 OVER
SUBT8 AS '' IN 10 OTT1 AS '' IN 34 OTT2 AS '' IN 49
COMPUTE
IX/P5.2=OTT1/OTT2; AS '' IN 58
OTT3 AS '' IN 75 OTT4 AS '' IN 91
COMPUTE
IX/P5.2=OTT3/OTT4; AS '' IN 101 OVER
BK1 AS '' OVER
SUBT10 AS '' IN 10 T1 AS '' IN 34 T2 AS '' IN 49 T3 AS '' IN 75 T4 AS '' IN 91
-*
FOOTING
"OP0031(vk)"
ON TABLE PCHOLD FORMAT PDF
-*ON TABLE SET ONLINE-FMT PDF
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
UNITS=IN,
SET PCHOLD-FMT=BINARY
PAGESIZE='LETTER',
LEFTMARGIN=0.2500000,
RIGHTMARGIN=0.2500000,
TOPMARGIN=0.2500000,
BOTTOMMARGIN=0.2500000,
SQUEEZE=OFF,
ORIENTATION=PORTRAIT,
WRAP=OFF,
$
TYPE=REPORT,FONT=COURIER NEW,SIZE=8,$
TYPE=HEADING,LINE=1,JUSTIFY=CENTER,FONT=TIMES NEW ROMAN,SIZE=9,STYLE=BOLD,$
TYPE=HEADING,LINE=2,JUSTIFY=CENTER,FONT=TIMES NEW ROMAN,SIZE=9,STYLE=BOLD,$
TYPE=HEADING,LINE=4,FONT=TIMES NEW ROMAN, SIZE=8,STYLE=ITALIC+BOLD+UNDERLINE,$
TYPE=FOOTING,SIZE=7,$
TYPE=REPORT,FIELD=TITLEA,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEB,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEC,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLED,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEE,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEF,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEG,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEH,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEI,STYLE=BOLD,$
TYPE=REPORT,FIELD=SUBT18,STYLE=UNDERLINE,$
TYPE=REPORT,FIELD=SUBT19,STYLE=UNDERLINE,$
TYPE=REPORT,FIELD=SUBT20,STYLE=UNDERLINE,$
ENDSTYLE
END


Valeriya

WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000
October 16, 2007, 10:26 AM
vkrugman
WF version 523 and thanks for your help


Valeriya

WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000
October 16, 2007, 10:30 AM
Francis Mariani
1) SET PCHOLD-FMT=BINARY is not WebFOCUS styling, therefore it should not be coded within the style-sheet
2) SET PCHOLD-FMT=BINARY is not valid WebFOCUS syntax - I've never seen this before
3) You already have ON TABLE PCHOLD FORMAT PDF - you should not be entering code to hold the report in another format.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
October 16, 2007, 10:33 AM
Francis Mariani
I don't know why the line of code gets generated. Could you rebuild the style-sheet using the GUI (which I assume how the report was built)?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
October 16, 2007, 10:34 AM
Prarie
Also that line is within the Stylesheet. What is that line supposed to be doing?


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
quote:
SET PCHOLD-FMT=BINARY

I have no idea what and how this line is doing!
I've just reran my code by deleting this line and it worked. It WORKS if I urn it from developer studio. As soon as I run a report from an application that SET PCHOLD-FMT=BINARY line returnes back to the same place! Do you think I need to recode the style-sheet? Thank you to all!


Valeriya

WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000
quote:
SET PCHOLD-FMT=BINARY


This looks like a bug. You will have to login to Tech Support to see this document, but it appears there's a patch to Dev Studio to correct the problem.
Developer Studio Upgrade/Service Pack 5.2.8

I searched for "SET PCHOLD-FMT=BINARY" (with the double-quotes) in Tech Support.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
THANKS, Francis! I l'll take a look!


Valeriya

WebFOCUS 764 Servlet - MRE/Dashboard/Self Service/ReportCaster - Windows 2000