Focal Point
Very annoying error generated when using () in FEX code

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7081057331/m/9051009331

October 06, 2005, 02:17 PM
Francis Mariani
Very 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
    jimster06
    Francis-
    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 Mariani
    It'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
    susannah
    Francis, 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 Mariani
    Susannah,

    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.