Why not? If you get correct data than problem is most likely with Report Manager not ODBC.
>Thanks Sergey but will running this from VFP itself give true results?
>
>>By running tests with SPT you could see if Report Manager or ODBC is responsible for this problem.
>>
>>>>SPT - SQL Path-Through. You connect to the data source using the SQLCONNECT( ) or SQLSTRINGCONNECT( ) function and send SQL statement to a backend using SQLEXEC( ) Function.
--sb--