Hello Subramanian,

Thanks for your contribution to the UT download section.
I have downloaded your crosstab program, gsxtab1.PRG, and I'm using it in VFP7. First I removed the few lines of code that used SET ENGINEBEHAVIOR, since that command is not in VFP7 Then, this is how I tested it:

SELECT * FROM timebook INTO CURSOR tbr NOFILTER
SELECT timebook
USE
SELECT tbr
DO gsXtab1 WITH [tbrxtab.dbf],.T.,.T.,.T.,2,3,4
USE
RETURN

The program throws a "Syntax" error at line 281 &lcSQL. This is what was in that variable (over 300 characters, so I wrapped the lines for display here):

SELECT A.*, ;
	SUM(A.TBR_RE*B._04879) AS '_04879' , ;
	SUM(A.TBR_RE*B._04880) AS '_04880' , ;
	SUM(A.TBR_RE*B._04881) AS '_04881' , ;
	SUM(A.TBR_RE*B._06283) AS '_06283' , ;
	SUM(A.TBR_RE*B._07709) AS '_07709' ;
	FROM TBR A, gsXtemp B ;
	WHERE B.TBR_EMPNO=A.TBR_EMPNO ;
	GROUP BY 1 ORDER BY 1 ;
	INTO CURSOR tbrxtab.dbf READWRITE

Can you help me solve the problem? Perhaps I've made an error calling the program?

Thanks for your time.