Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
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, 2005Report 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, 2003Report 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, 2005Report 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, 2003Report 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, 2005Report This Post
      Powered by Social Strata  

    Read-Only Read-Only Topic

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

    Copyright © 1996-2020 Information Builders