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,
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
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 |
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