October 06, 2005, 02:17 PM
Francis MarianiVery annoying error generated when using () in FEX code
Why do I get this error when I post this code?
quote:
Sorry, we do not permit the following HTML tag or attribute: Parenthesis in HTML tag
� Please use your browser's back button to return.
There's no HTML in this post - just WebFOCUS code. When I use the back button I lose what I just entered - very annoying.
[I had to change the parentheses to [] to post this message in the FOCUS/WebFOCUS forum].
Ken, I think thangam was attempting to set up a kind of Index line of hyperlinks that would navigate to different parts of the report.
I thought this would work, but I get the dreaded SocketException error:
An error has been detected during server to client data transfer.
ERROR: -12: Pcb2.: java.net.SocketException: Connection reset
-*-- Drillthrough example
-SET &ECHO=ALL;
-*
SET ORIENTATION=LANDSCAPE
-RUN
-*
TABLE FILE GGSALES
SUM CATEGORY
ACROSS CATEGORY NOPRINT
ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=CATEGORY
, COLOR=GREEN, DRILLTHROUGH=DOWN[CATEGORY], $
ENDSTYLE
END
-RUN
-*
-GOTO THREE
-*
TABLE FILE GGSALES
SUM UNITS DOLLARS
BY CATEGORY
BY PRODUCT
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=PRODUCT, DRILLTHROUGH=DOWN[CATEGORY PRODUCT], $
ENDSTYLE
END
-RUN
-*
-THREE
TABLE FILE GGSALES
SUM UNITS BUDUNITS DOLLARS BUDDOLLARS
BY CATEGORY NOPRINT
BY PRODUCT NOPRINT
ON CATEGORY PAGE-BREAK
HEADING CENTER
"Category: " "
ON PRODUCT SUBHEAD
"**** Product: BY CITY
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET STYLE *
TYPE=HEADING, LINE=1, OBJECT=FIELD, ITEM=1, DRILLTHROUGH=FIRST[CATEGORY], COLOR=GREEN, $
-*TYPE=SUBHEAD, LINE=1, ITEM=2, DRILLTHROUGH=FIRST[CATEGORY PRODUCT], COLOR=RED, $
ENDSTYLE
END
-RUN
October 06, 2005, 02:43 PM
jimster06Francis-
Consider the use of UBB tags around your code. See the "code" button in the "Instant UBB Code" area. You have to use full reply. I got the same trap on Monday.
HTH
October 06, 2005, 03:27 PM
Francis MarianiIt's strange - this worked!
-*-- Drillthrough example
-SET &ECHO=ALL;
-*
SET ORIENTATION=LANDSCAPE
-RUN
-*
TABLE FILE GGSALES
SUM CATEGORY
ACROSS CATEGORY NOPRINT
ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=CATEGORY(*), COLOR=GREEN, DRILLTHROUGH=DOWN(CATEGORY), $
ENDSTYLE
END
-RUN
-*
-GOTO THREE
-*
TABLE FILE GGSALES
SUM UNITS DOLLARS
BY CATEGORY
BY PRODUCT
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=PRODUCT, DRILLTHROUGH=DOWN(CATEGORY PRODUCT), $
ENDSTYLE
END
-RUN
-*
-THREE
TABLE FILE GGSALES
SUM UNITS BUDUNITS DOLLARS BUDDOLLARS
BY CATEGORY NOPRINT
BY PRODUCT NOPRINT
ON CATEGORY PAGE-BREAK
HEADING CENTER
"Category: " "
ON PRODUCT SUBHEAD
"**** Product: BY CITY
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET STYLE *
TYPE=HEADING, LINE=1, OBJECT=FIELD, ITEM=1, DRILLTHROUGH=FIRST(CATEGORY), COLOR=GREEN, $
-*TYPE=SUBHEAD, LINE=1, ITEM=2, DRILLTHROUGH=FIRST(CATEGORY PRODUCT), COLOR=RED, $
ENDSTYLE
END
-RUN
October 06, 2005, 06:21 PM
susannahFrancis, buy me a vowel, would you?
i've never seen this syntax
DRILLTHROUGH=...
There's no listing for the word (that i can find) in the 53 manuals index. The kbsite search turned up nothing useful.
Where is the fexname? what is the meaning of DOWN and FIRST? is this pdf only?
October 06, 2005, 07:00 PM
Francis MarianiSusannah,
This is for PDF only and allows you to navigate to different parts of a PDF Compound report.
You're right, it's not in the index, but look for "Creating Drill Through PDF Compound Reports" in the Creating Reports With WebFOCUS Language Version 5 Release 3 document.
I've never used it but was trying to help someone out.
Cheers.
Francis.