Is this query that shows all of your data correctly a query that has all of your tables and joins that are being used in the crystal report or is it just querying one table or your stored proc alone? If you are querying them alone try and build the full SQL with all the tables and joins together exactly the same as your crystal report to see if you still have different results.

 

Are there any parameters in any of your oracle that Crystal is not catching but you are putting in on your SQL query that works.

Do you have more than one version of the DB and is the crystal ODBC pointing to the same DB version as your SQL query is that works?

 

Try "Database" > "Verify Database" option to make sure any changes to your Stored Proc (or tables or views) have been updated in the report as well.

 

Any of these work or explain the difference?

Also make sure to use the Verify DB whenever you alter a Stored Proc or view. Crystal does not automatically update this if you have them open and working on them at the same time.

   One thing I noticed is , that this works correctly on our TEST server and not on PROD server, but I really dont think that there is much difference between PROD and TEST data as the data was refreshed recently. So where could the problem be ?

Please advise.

 

Thanks