I want a conditional drill down from an across field.
It seems however not to work.

any suggestions?

TABLE FILE CAR
SUM
SALES
ACROSS COUNTRY
BY SEATS
ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=SALES, FOCEXEC=TESTBB (COUNTRY=COUNTRY SEATS=SEATS), $
TYPE=ACROSSVALUE, FOCEXEC=TESTCC (COUNTRY=COUNTRY), $
END

Oops, forgot about the conditional drill-down!

By the way:

I for h-I-m e.g. Francis Sinatra.
E for h-E-r e.g. Frances Farmer.

Cheers

Not working for me. I changed the drilldown to make sure the missing procedures were not killing the drilldowns:

TABLE FILE CAR
SUM
SALES
ACROSS COUNTRY
BY SEATS
ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=SALES, URL=http://www.google.com, WHEN=COUNTRY EQ JAPAN,$
TYPE=ACROSSVALUE, URL=http://www.google.com,WHEN=COUNTRY NE JAPAN, $
END

The WHEN conditions don't seem to be respected. Remove the WHEN conditions and the drilldown appear. Any thoughts?

me neither , Chris. i've never been able to get conditionals and across's to cooperate.

Here's another example initially created in Dev Studio and then extended:

TABLE FILE CAR
SUM
     COUNTRY NOPRINT
     SALES
ACROSS COUNTRY
BY SEATS
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
     DEFMACRO=COND0001,
     MACTYPE=RULE,
     WHEN=N2 EQ 'JAPAN',
     URL=http://www.google.com,
$
     DEFMACRO=COND0002,
     MACTYPE=RULE,
     WHEN=N2 NE 'JAPAN',
     URL=http://www.yahoo.com,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=DATA,
     ACROSSCOLUMN=N2,
     MACRO=COND0001,
$
TYPE=DATA,
     ACROSSCOLUMN=N2,
     MACRO=COND0002,
$
ENDSTYLE
END

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

FYI, the proper syntax to refer to the ACROSSVALUES of a particular ACROSS field is

TYPE=ACROSSVALUE, ACROSS=COUNTRY, ...

However, the conditional styling still does not seem to work at least with WF713.

If I take gregv's example as is, it works.
If I use mgrackin's syntax, it does not work any more.
Anyway, the only drawback of greg's solution is that every no-data cell will always drill down into the yahoo url, so in the macro where the country is not equal to japan.
As far as I know, the only way around that (if you need to go around it), is by using a holdfile to be able to create the correct intermediate values for missing data.