hi friends ,

Thanks a lot for your help and suggestions. I owe a lot to all of you.

I am having a report which is having around 1 million records ( dunno how are they gonna c all the records ) ...

I used the BYTOC function as mentioned in the technical documentation. But i figured that it is displaying the Worksheet number in the titletext and not the customized titletext which i gave.

Is there any work-around or any other code-tweaking that can be done??
Because here the higher grouping is done by the worksheet virtual field. Below is my code.
After you run it , you can see the worksheet value 0 in the titletext.
Thanks again .

TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
BODYTYPE
SEATS
DEALER_COST
RETAIL_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K OPEN
ON TABLE SET STYLE *
type=report, titletext='Summary Report', $
ENDSTYLE
END
TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
COMPUTE COUNTER/I7=COUNTER + 1; NOPRINT
COMPUTE WORKSHEET/I3=COUNTER/65000; NOPRINT
BY TOTAL WORKSHEET NOPRINT
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
BY SEATS
ON TABLE PCHOLD FORMAT EXL2K BYTOC CLOSE
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT = 'MAIN REPORT',
$
END

Arvind,

Because you are using BYTOC, WF is using the values of WORKSHEET as titletext.

So if you want somthing else, you have to calculate it:

  
COMPUTE WORKSHEET/I3=COUNTER/65000; NOPRINT
COMPUTE TITLESHEET/A15='MAIN REPORT ' | EDIT(WORKSHEET); 
BY TOTAL TITLESHEET NOPRINT

delete BY TOTAL WORKSHEET

thanks a lot daniel ,

Simple solution yet it evades me all the time