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  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Conditional formatting not working on hyperlink?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Conditional formatting not working on hyperlink?
 Login/Join
 
Member
posted
I want a nice blue underlined link when there is something to drill down on, and blank normal text where there is nothing to drill down on, Or, ideally, no hyperlink at all.

I get the nice blue underline when the condition SOME_RECORD_FAILS is true, but when NO_RECORD_FAILS is true I get a weird light blue. Anyone have any ideas?

Thanks!

-Jeff


 

TYPE=DATA,
     COLUMN=N4,
     COLOR='BLACK',
     MACRO=NO_RECORD_FAILS,
     DRILLMENUITEM='Download Records Needing Remediation',
          FOCEXEC=IBFS:/WFC/Repository/Public/Record_Data_Quality/Record-Failure-Detail-Report.fex( \
     CAL_YR_MTH=N1 \
     Vendor=N3 \
     DQ_RULE_DESC=N4 \
     DQ_PROCESS_DESC=N2 \
     ),
          TARGET='_blank',
$
TYPE=DATA,
     COLUMN=N4,
     COLOR='BLUE',
     STYLE=UNDERLINE,
     MACRO=SOME_RECORD_FAILS,
     DRILLMENUITEM='Download Records Needing Remediation',
          FOCEXEC=IBFS:/WFC/Repository/Public/Record_Data_Quality/Record-Failure-Detail-Report.fex( \
     CAL_YR_MTH=N1 \
     Vendor=N3 \
     DQ_RULE_DESC=N4 \
     DQ_PROCESS_DESC=N2 \
     ),
          TARGET='_blank',

 

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8105
 
Posts: 5 | Registered: July 05, 2018Reply With QuoteReport This Post
Member
posted Hide Post
So, I just took out the DRILLDOWN on the condition I didn't want it to, and it turned black AND removed the drilldown.

Maybe drilldown won't allow black font?

Anyways, I solved it, but leaving this for others.


WebFOCUS 8105
 
Posts: 5 | Registered: July 05, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Why do you add a DRILLMENUITEM, FOCEXEC and TARGET when you don't want a hyperlink/drilldown?


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1630 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
Jeff,

I would check your MACROs.

Try this example to show that it can be achieved if you have the correct checks etc.
TABLE FILE GGSALES
SUM COMPUTE C_DOLLARS/D12.2c = IF CITY CONTAINS 'a' THEN 0 ELSE DOLLARS; AS 'Amount'
BY REGION
BY ST
BY CITY
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
  TYPE=DATA, COLUMN=C_DOLLARS,
     COLOR='BLACK',
     WHEN=C_DOLLARS NE 0,
     DRILLMENUITEM='Download Records Needing Remediation',
          FOCEXEC=carinst.fex,
     TARGET='_blank',
$
ENDSTYLE
END
-RUN


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.05 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.05 standalone on Windows 10 
 
Posts: 5524 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Master
posted Hide Post
Use the WHEN statement in your drilldown. Back when we first started using WebFOCUS (original reports were in FOCUS/HP-UX). We developed our own security for giving access to reports based on the security in the user application that maintains the database. We have reports that are summary in nature and everyone can see those but drilling down to detail requires that one have the proper security in the application. In the following, the user id is passed to WebFOCUS. That is then checked in staff table. For anyone without the proper permissions, their &&WORKERTYP is set to 'G' for Guest. They can run the report but have cannot drill to the supporting detail. For example:
 
 TABLE FILE MGMTDATA
   SUM PSRTKEY AS '&SRTHD' OVER
       INPCT   AS '% Within Policy' OVER
       DENOM   AS 'Completed' OVER
       NUMER   AS 'Within Policy' OVER
       DIFF    AS 'Not Within Policy' OVER
       ALOT    AS 'ALOT to Complete (Days)'
       COMPUTE DRILL3/I2=DENOM GT 0 AND '&&WORKERTYP' NE 'G'; NOPRINT
       COMPUTE DRILL4/I2=NUMER GT 0 AND '&&WORKERTYP' NE 'G'; NOPRINT
       COMPUTE DRILL5/I2=DIFF  GT 0 AND '&&WORKERTYP' NE 'G'; NOPRINT
       MAX.SRTKEY NOPRINT
ACROSS SRTLVL  NOPRINT
ACROSS PSRTKEY NOPRINT
FOOTING
"&FOOT1"
"Data Collected on &&RUNTIME"
    ON TABLE SET PAGE-NUM NOLEAD
    ON TABLE SET PRINT ONLINE
    ON TABLE NOTOTAL
    ON TABLE HOLD AS DATA1 FORMAT HTMTABLE
    ON TABLE SET STYLE *
 TYPE=REPORT, GRID=ON, FONT='CALIBRI', SIZE=10,$
 TYPE=TITLE, WRAP=OFF,$
 TYPE=TITLE,ACROSSCOLUMN=N1,BACKCOLOR=&TABCDFTBCR,$
 TYPE=TITLE,ACROSSCOLUMN=N2,COLOR=&TABCPCTFCR,BACKCOLOR=&TABCPCTBCR,$
 TYPE=TITLE,ACROSSCOLUMN=N3,BACKCOLOR=&TABCDFTBCR,$
 TYPE=TITLE,ACROSSCOLUMN=N4,BACKCOLOR=&TABCTOTBCR,$
 TYPE=TITLE,ACROSSCOLUMN=N5,BACKCOLOR=&TABCDFTBCR,$
 TYPE=TITLE,ACROSSCOLUMN=N6,BACKCOLOR=&TABCDFTBCR,$
 TYPE=DATA,JUSTIFY=CENTER,$
 TYPE=DATA,ACROSSCOLUMN=N1,BACKCOLOR=&TABDDFTBCR,$
 TYPE=DATA,ACROSSCOLUMN=N2,COLOR=&TABDPCTFCR,BACKCOLOR=&TABDPCTBCR,$
 TYPE=DATA,ACROSSCOLUMN=N3,BACKCOLOR=&TABDDFTBCR,$
 TYPE=DATA,ACROSSCOLUMN=N4,BACKCOLOR=&TABDTOTBCR,$
 TYPE=DATA,ACROSSCOLUMN=N5,BACKCOLOR=&TABDDFTBCR,$
 TYPE=DATA,ACROSSCOLUMN=N6,BACKCOLOR=&TABDDFTBCR,$
$
$  Run Detail Reports
$
 TYPE=DATA, ACROSSCOLUMN=N3, &DTLFEX ROWNUM='3' &MDTLPARM, TARGET=_BLANK, WHEN=DRILL3 GT 0,$
 TYPE=DATA, ACROSSCOLUMN=N4, &DTLFEX ROWNUM='4' &MDTLPARM, TARGET=_BLANK, WHEN=DRILL4 GT 0,$
 TYPE=DATA, ACROSSCOLUMN=N5, &DTLFEX ROWNUM='5' &MDTLPARM, TARGET=_BLANK, WHEN=DRILL5 GT 0,$
 ENDSTYLE
 END
-RUN


When DRILL3/DRILL4/DRILL5 are 0, the data appears but the drill links are not there.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 900 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Conditional formatting not working on hyperlink?

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