Print Page | Close Window

Error when SQL table returns no results

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1370
Printed Date: 05 Apr 2025 at 7:54pm


Topic: Error when SQL table returns no results
Posted By: amgaudet
Subject: Error when SQL table returns no results
Date Posted: 24 Sep 2007 at 8:12am

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é


Replies:
Posted By: p&ccrystal
Date Posted: 04 Oct 2007 at 12:08pm

How is the Select statement written? It may have to do with the wording in the select statement. Do you use an input mask so that users cannot enter data that Crystal does not recognize as a date or whatever field type used for the CC number?

An invalid data type can cause Crystal to freeze.


-------------
10 year user of Crystal Reports - recently implemented Crystal Server 11.5

Posted By: amgaudet
Date Posted: 04 Oct 2007 at 12:16pm
The statement is quite simple:
 
SELECT *
FROM   ARInvoiceDetails
WHERE  TransactionDate >= {?Date1} AND TransactionDate <= {?Date2} AND TicketNumber= {?CC Number}
 
I'm the only one that uses this report and I do enter the card with the ' on each end therefore I didn't have to use an input mask however that is a good idea.
 
The dates parameters are in a date variable and the CC number Parameter is a string.
 
Thanks for your help.
André


Print Page | Close Window