Quote Originally Posted by mbarnett View Post
Did you look at the query after running each report to see that they are the same?

I would check again to make sure you did not at some time save the report with data.

I have had reports error before because the query treated a 1 as a string on one run or machine and then as a true on anther machine. I still have not had time to figure out why that happens but it may be related to your problem.

If this is on a domain? Does the user on pc b Have the same privileges?
I have written reports that only allow certain people access to certain data but i do that on purpose. but still might be an area to look at.

check the relationships on the second report...

just because the odbc is pointing to the same server does not mean the same database on the server. check the odbc connection on pc b again to make sure your logging onto the correct database

"and so on means" we could list hundreds more things to check without more detail of your report.
1. query is the same.
2. if i copy report from pc A to pc B, the save data with report option should be same rite?
3. pc A & pc B are in same domain, privileges not sure, need check.
4. will check the odbc setting again.

Remarks: only 1 or 2 report got this error, other reports working fine.