In the focexec below, is there a way for me to pass all the values of CAR that showed up in the report to the drilldown in the footing?

  
TABLE FILE CAR

PRINT 
     CAR
     COUNTRY
     SALES
BY SEATS
WHERE SALES GT 10000
ON TABLE SUBFOOT
"Drill to another report with all values of CAR"
ON TABLE SET STYLE *
TYPE = TABFOOTING,FOCEXEC=TEST(CARS = ?),$
ENDSTYLE
END

This message has been edited. Last edited by: ChannyS,

The fex called by the drilldown receives whatever values you pass it in the form of amper vars. So first you have to decide what form the set of var names and values is to take
-- for example:

a. a single variable:
&CARS : comma-delimited list of values

b. a set of related vars such as a multi-select would pass:

&CAR0 = counter
&CAR1 = value
&CAR2 = value
etc.

Either way, in the report fex you would use an initial TABLE ... HOLD, plus some dialog manager, to capture the data in &vars, and then generate appropriate code in the stylesheet section of a second TABLE request to produce the formatted report with the approriate drilldown.

Thanks, I will do the hold and read from the hold and build up a list that way.