Re: Creating Reports

Dale E. Reed Jr. ( (no email) )
Sat, 07 Mar 1998 13:58:12 -0800

Gary D. Walworth wrote:
> That's basically what I had done originally, until the accountant told me
> about the need for invoice numbers on the report. In order to do that, I
> would need to bring in the Invoices and InvoiceItems tables, as there is no
> reference in the Payments table... correct?

Correct. I'm not sure why they need invoice numbers, though. In
Emerald 2.5, a payment does not have to be associated to an invoice
(for Balance forward situations).

> BTW, I figured out the reason for the "ODBC Error:Driver Not Capable"
> message in Crystal Reports. After comparing some reports I had made with
> some reports on the FTP Server, I narrowed it down to the Report Options in
> CR. All of the reports that work do *not* convert the Date-Time string. When
> it is converted to Date (only in Report Options!), the error message occurs.
> I don't know if this is something I had done originally when setting up CR
> or SQL. Does this happen to anyone else?

Yeah, I noted to check that option previously. I don't know why either,
but it seems to cause problems when set one way.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |