Report generates different data depending on computer

[dstrange]

A report that used to work for me (I created the report) seemingly doesn't return any data anymore but when the app is ran on another computer it will display the correct data. Both computers are running the same .exe file and connect to the same database. Has anyone seen this before?

 

[kss444]

Are the Database user the same on each machine?

 

[Madawc]

If it is the same database - Database > Set Location gives a quick look - then check if the date is the same for both. Try writing a little test Crystal to see if this is general or specific to that report.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods change between versions, and higher versions have extra options.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Also try going to database->verify database.

-LB

 

[gortuk]

You might want to make sure that what you think is the same database on both computers actually is the same database. For instance, if it's an ODBC connection you might have the same name but be pointing to different servers. Or if it's an Oracle database and was recently moved, you might be pointing to different SIDs in your tnsnames.ora file.