Invoices will not print

Greg Keys ( (no email) )
Wed, 3 Jun 1998 17:23:08 -0400

Here is a fun one for all of you.

1. Went to the Batch tab in Emerald 2.2.38
2. Put in a date of the 17th of June and an Invoice Type of Renewal
3. Created the invoices
(so far, no problems: Created a bunch of Invoices)
4. Set the date to Todays Date
5. Selected Print
6. The Invoice Report (CR Screen) Flashed up, disappeared, and a little box
appeared saying "SQL Error"

Now, before anyone asks, I am running CR 6.0 and it is installed on the same
The report will run from inside crystal reports.
I even went so far as to go to the FTP site and download the CR60
Invoice.rpt file and replace my rpt file in case I changed something in the
report that was a booboo. Results??? (See above :)


P.S. If I go into CR60 and set the Selection Criteria to check the Invoice
Date=date(xxxx,x,x) and isnull(sentdate) the report still runs from within
If I add Type="Renewal" to the criteria I get and ODBC Driver

Gregory E. Keys
System Administrator
LoclNet (A Division of ESC Inc.)
Electro-data Systems Company Inc.
Voice: (704)861-1251
Fax: (704)861-1870