I'm currently using a simple SQL query to create a table in my report. The query basically looks at the record date using a user imputed paramater as well as a credit card number entered by the user as well. The result is a table containing only the applicable records.
My problem occures when the CC number is not found. Rather than get a "No data found" error or any type of message at all, the report freezes Crystal at the "Accessing Database" stage. If there is a record that fits the criteria, the report works perfectly.
Has anyone else seen this and hopefully found a way around it?
Thank you,
André