Report shows different number of records than SQL query
Posted on 2006-07-07
I saw a similar question title already in here but this one is different...
At the simplest level, I have a report in Crystal XI Developer that returns 123 records. However, when I copy the SQL query from Database->Show SQL Query... and paste that into SQL Query Analyzer and run it directly against the data source, it returns 125 records.
What can cause the number of records to be different?
The 2 records missing from the report seem to meet all of the criteria in the record selection formula. I don't have a group selection formula. What else would cause Crystal to omit records that were returned by the SQL query?