Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  Rules, Regulations, and FAQs    Very annoying error generated when using () in FEX code
Go
New
Search
Notify
Tools
Reply
  
Very annoying error generated when using () in FEX code
 Login/Join
 
Expert
posted
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
  •  
    Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
    Guru
    posted Hide Post
    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
     
    Posts: 252 | Location: USA | Registered: April 15, 2003Reply With QuoteReport This Post
    Expert
    posted Hide Post
    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
     
    Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
    Expert
    posted Hide Post
    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?
     
    Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
    Expert
    posted Hide Post
    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.
     
    Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
      Powered by Social Strata  
     

    Focal Point    Focal Point Forums  Hop To Forum Categories  Rules, Regulations, and FAQs    Very annoying error generated when using () in FEX code

    Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.