Focal Point
[CLOSED] Conditional formatting not working on hyperlink?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1557030196

January 11, 2019, 03:31 PM
JayInBoston
[CLOSED] Conditional formatting not working on hyperlink?
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
January 11, 2019, 03:35 PM
JayInBoston
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
January 14, 2019, 08:23 AM
Wep5622
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 :
January 14, 2019, 08:43 AM
Tony A
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.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
January 14, 2019, 09:05 AM
jgelona
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.