Same report; 2 different computers; 2 different results

[Rena]

I have a report that was written in V7. It uses ODBC to access 3 Visual Fox Pro databases. We have recently upgraded to V8.5. When I run this report on my computer, I get the expected records. When a co-worker runs the same report on her computer, she gets no records. I have checked the ODBC and everything appears to be the same. One catch that I'm not sure is relevant. This report selects on a field that VFP calls a logical field. In Crystal, it displays as 1.00 or 0.00 so the select uses this and it has worked fine. Plus two of the databases use a VisualFox Pro ODBC and the third uses an ODBC that I created that points to VFP. I hope all this makes sense. Any suggestions on why this report gets different results on the different computers. BTW - we are both WinNT.

Thanks,
Rena

 

[JustineB]

Did you both upgrade in the same way?
If you have different version of Crystal .dll's on each machine, you will get different results.

 

[Rena]

I think we did. She actually upgraded first (a couple of months ago). I upgraded yesterday and expected to get the same results when I ran the report in question that she had been getting and was surprised when it worked fine. We did try to reinstall her CRW8.5. We ran into an error that is too lengthy to explain here but we finally got it reinstalled. The report still produced no records. Then we un-installed it and did a full install again. Still no records. I will check our dlls and see if I can find a difference.

 

[Rena]

We compared our dlls and they are all the same with the exception of a few that had different modified TIME. File size and date was all the same.

Does anybody else have any suggestions?