Hi,

How do you make the drilldown to be only on the grandtotal title instead of the drill down on the whole line?
For example,

my report has:

grandtotalofxyz 1000 2000 3000 4000

now when I write the code as,

TYPE=GRANDTOTAL, FOCEXEC=XYZ,$

it highlights the whole line to be drilldown. I want to show the drilldown only on
"grandtotalofxyz" and not on the numbers. Is this possible?

TYPE=GRANDTOTAL,COLUMN=XXX,FOCEXEC=XYZ,$
where xxx is the fieldname you want to dd on.

Hi Susannah,

I guess you got my question wrong. I do not want to drill down on any of the fields or columns.
I just want to drill down on the title of the grandtotal which is

"grandtotalofxyz"

in my example.

I think so.

TABLE FILE CAR
PRINT CAR MODEL SEATS
BY COUNTRY SUBTOTAL
ON TABLE NOTOTAL
ON TABLE SUBFOOT
"GRANDTOTALOFXYZ <TOT.SEATS"
ON TABLE SET STYLE *
TYPE=TABFOOTING,HEADALIGN=BODY,$
TYPE=TABFOOTING,OBJECT=TEXT,COLSPAN=3,
FOCEXEC=XYZ,$
TYPE=TABFOOTING,OBJECT=FIELD,JUSTIFY=RIGHT,$
ENDSTYLE
END

trying that.