Hi
Is there a way where i can specify different FOCEXEC's to different column's under Acrosscolumn.

Supose under
AcrossColumn
P1 P2 P3
1 2 3
1 2 3
1 2 3

For Column P1 -- I would like to FOCEXEC1
P2 --Focexec2
p3 --Focexec3

Thanks

You can have all the columns drill to one fex, and pass the across-field as a parameter. The called fex can then compute what fex to call, and invoke it via -INCLUDE or EX:
thus:

-SET &report =DECODE &PARM(val1 fex1, val2 fex2, ...);
-INCLUDE &report.EVAL

All you need to do is use column addressing for the drilldown

TABLE FILE CAR
SUM SEATS
ACROSS COUNTRY
ON TABLE PCHOLD FORMAT L
ON TABLE SET STYLE *
TYPE=ACROSSVALUE,COLUMN=C1,COLOR=
BLUE,STYLE=BOLD,FOCEXEC=ENGLAND(
COUNTRY=COUNTRY),$
TYPE=ACROSSVALUE,COLUMN=C2,COLOR=
BLUE,STYLE=BOLD,FOCEXEC=FRANCE(COUNTRY=COUNTRY),$

END

This message has been edited. Last edited by: <Mabel>,

quote:

Originally posted by JG:
[qb] All you need to do is use column addressing for the drilldown
. . .
[/qb]

Provided the across value for each column is absolutely predictable.

I should not have used the ACROSS value as the name of the drilldown focexec in the example as it implies the requirement to pre know the ACROSS contents and order.

The predictability of the ACROSS order is relevant if you want to run a focexec dependant on it�s value.
If you always want to run focexec A.fex for column 1 focexec B.fex for column 2 etc.
then it�s not important.
The relevant ACROSS value is always populated into the ACROSS field when
referenced in the style sheet for drilldown or conditional testing usage.

Where predictability is relevant however is in the number of ACROSS values. In your style sheet you need to code for the maximum possible number of occurrences otherwise you will have some columns that do not have a drilldown available to them.