Hi All,

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

Hi nsk110483,

Is this what you're looking to do?

PARENT.FEX:

  
TABLE FILE CAR
PRINT COUNTRY
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=COUNTRY, FOCEXEC=DRILL(COUNTRY=COUNTRY),$
ENDSTYLE
END

DRILL.FEX:

 
TABLE FILE CAR
HEADING
"DRILL DOWN REPORT"
PRINT COUNTRY
WHERE COUNTRY EQ '&COUNTRY';
END

Cheers!

Kathryn

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.

nsk,

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,