I have a report having Region as by field.
When i do a subtotal on Region (ON REGION SUBTOTAL AS 'Total'),
the display is coming as >>
Total Region 0000
Total Region 0100
likewise...
But i want the subtotal title as "Total".
any pointer how to accomplish the same ??

tks/sam

How about using SUBFOOT like

ON REGION SUBFOOT "Total: <SUM.THEFIELD" 

and have the alignment controlled by CSS?

any alternate ?
my code is bit complicated, so i can't go for this approach ............

Try this!

DEFINE FILE CAR
Total/A5 WITH COUNTRY ='Total';
END
TABLE FILE CAR
SUM SALES 
BY COUNTRY
BY Total  NOPRINT SUBTOTAL AS ''
BY CAR
END