Hello,

-HTMLFORM BEGIN
0 NUMBER OF RECORDS IN TABLE= 17 LINES= 1
0 NUMBER OF RECORDS SELECTED= 11 LINES= 11
0 NUMBER OF RECORDS SELECTED= 1 LINES= 1
0 LINES OF MATCH OUTPUT = 11
0 NUMBER OF RECORDS IN TABLE= 11 LINES= 11
(FOC3202) BAD VALUE IN STYLESHEET FILE AT LINE 243: WHEN=CLASSFLAG EQ '
BYPASSING TO END OF COMMAND
-HTMLFORM BEGIN
(FOC36225) UNABLE TO OPEN FILE H1 SPECIFIED BY WEBFOCUS TABLE
-HTMLFORM END

^I'm recieving a FOC3202 Error when I run a report in Version 7.7.0.3, but when I run the same report on another server that still uses version 7.6.1.1 the report works fine. We are migrating to a new server so I need it to work with new version.

The report is called using a link constructed through our web application. Clicking the retrieve button runs the report and takes the values off a html composed parameter screen, then uses the selected options in a WHERE statement to produce the desired report.

here is an example of our link that calls the report:

http://ihsda.ssatst1.sspf.ssa....H=January&Sample=All

When I look at the line (243) failing in the report its WHEN=CLASSFLAG EQ '' so possibly an issue using a blank space in the new version?

I'm wondering why there is a stylesheet issue in 7.7.0.3 and not 7.6.1.1? Thanks for any input.

This message has been edited. Last edited by: <Kathryn Henning>,

Not sure if this is really a problem in 7.7.03. But IBI when they go for higher version, they tighten the rules to fix loop holes in prior versions.

quote:

(FOC3202) BAD VALUE IN STYLESHEET FILE AT LINE 243: WHEN=CLASSFLAG EQ '

Can't tell much w/o seeing the code, but I gather ntisdqbs.fex had

WHEN=CLASSFLAG EQ ''

, and the new server is simply not seeing the second quote.

First, make sure the copy of ntisdqbs.fex on the new server is intact.

Next, try specifying a space, rather than an empty string:

WHEN=CLASSFLAG EQ ' '

The reports worked fine with the new version when I changed this line

WHEN=CLASSFLAG EQ ' '
To
WHEN=CLASSFLAG EQ '1'

COMPUTE CLASSFLAG/A1 = IF CLASSFLAG EQ ‘1’ (instead of null)


Thanks for all of your input