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.