Same Crystal Report Different Results

[ashly]

Dear all,

I need help urgently here. I have a crystal report (data.rpt), when view in PC A, I got result displayed at the report (Example: Data1 = 10). But when view in PC B, I got empty result where Data1 = 0.

I wonder why this would happen.


Please help & thanks

[jggtz]

It could be several reasons :
1.- Different rpt version
2.- They are 'seeing' different data sources
3.- rpt is saved with data
4.- and so on

[ashly]

It could be several reasons :
1.- Different rpt version
2.- They are 'seeing' different data sources
3.- rpt is saved with data
4.- and so on

1. report version is the same. (I copy the report from PC A to PC B)

2. how to confirm that they are 'seeing' the same data sources?
- used ODBC system DNS & checked pointing to same server

3. same as 1. (I copy the report from PC A to PC B)

4. and so on means?

Weird case

[mbarnett]

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.

[ashly]

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.