How to provide drilldown on Subtotal-Title ??
I want drilldown at "Total Country" level.
Look at the below code(simple one)..i tried providing drilldown based on column value...but not working.
TYPE=SUBTOTAL,BY=1,COLUMN=N1/N2... none working.
But if you change it to N3, its creating hyperlink on RETAIL_COST succesfully.....

 
TABLE FILE CAR
PRINT 
     RETAIL_COST
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL AS 'TOTAL'
ON TABLE SET PAGE-NUM OFF 
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,BORDER=LIGHT,FONT='VERDANA',SIZE=10,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,$
TYPE=SUBTOTAL,BY=1,COLUMN=N1,TARGET='_blank',FOCEXEC=sm2,$
ENDSTYLE
END

Stumped, I am!

I tried setting it up with the dreaded GUI, but, no dice!

I got this to work:

TABLE FILE CAR
PRINT 
     RETAIL_COST
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL AS 'TOTAL'
ON TABLE SET PAGE-NUM OFF 
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,BORDER=LIGHT,FONT='VERDANA',SIZE=10,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,$
TYPE=SUBTOTAL,BY=B1,TARGET='_blank',FOCEXEC=sm2,$
ENDSTYLE
END

Though the country and value have a link.

quote:

Though the country and value have a link.

- there's the rub.

If you're willing to do it, this will work:

Set up the drilldown for the whole Subtotal line, then set focexec=none for each of the columns in the subtotal, except the first one...

TABLE FILE CAR
PRINT 
RETAIL_COST
DEALER_COST

BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL AS 'TOTAL'
ON TABLE SET PAGE-NUM OFF 
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,BORDER=LIGHT,FONT='VERDANA',SIZE=10,COLOR='BLACK',BACKCOLOR='NONE',STYLE=NORMAL,$

TYPE=SUBTOTAL, BY=COUNTRY, TARGET='_BLANK',FOCEXEC=SM2,$
TYPE=SUBTOTAL, BY=COUNTRY, COLUMN=RETAIL_COST, FOCEXEC=NONE, $
TYPE=SUBTOTAL, BY=COUNTRY, COLUMN=DEALER_COST, FOCEXEC=NONE, $

ENDSTYLE
END

u rock !!!!!!!!