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
LoclNet (A Division of ESC Inc.)
Electro-data Systems Company Inc.