Are you seeing any values in either of the Crystal GUI's? You state you can see all of the values "in this query", does this mean you see them all when when you run the SQL query outside of crystal?
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?
Edited by DBlank - 01 Jun 2009 at 2:10pm