I have a request where I will print multiple values for a single field in a table. How can I achieve drill capability on each different value?
I appreciate your help.This message has been edited. Last edited by: <Kathryn Henning>,
In Focus since 2008
Windows 7 - IE,Chrome,Firefox
Excel, PDF, HTML, AHTML, XML
Is this what you're looking to do?
TABLE FILE CAR PRINT COUNTRY ON TABLE SET STYLE * TYPE=DATA, COLUMN=COUNTRY, FOCEXEC=DRILL(COUNTRY=COUNTRY),$ ENDSTYLE END
TABLE FILE CAR HEADING "DRILL DOWN REPORT" PRINT COUNTRY WHERE COUNTRY EQ '&COUNTRY'; END
I have done this by creating a define for a column which was two HTML Anchor statement with the web call. It took a while to get the syntx right. hint code in in simple HTML them wrap the WebFocus code around the string.
Web Focus 7.6.10 under Windows 2003
Do you mean that you want to do a different drill for each value?
Example with the CAR file, printing COUNTRY, you want to drill to:
FEX1 for ENGLAND
FEX2 for FRANCE
FEX3 for ITALY
and so on?
"Silence is consent."
I would do this as follows:
TABLE FILE CAR PRINT COUNTRY COMPUTE DD/A8=DECODE COUNTRY( ENGLAND FEX1 FRANCE FEX2 ITALY FEX3 JAPAN FEX4 ELSE FEX0); NOPRINT ON TABLE SET STYLE * TYPE=DATA, COLUMN=COUNTRY, FOCEXEC=DRILL(FEX=DD), $ ENDSTYLE END
The the called procedure:
-* Drill EX &FEX
Add parameters if necessary.This message has been edited. Last edited by: Danny-SRL,
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
|Powered by Social Strata|