Re: [Emerald] Labels & Reports

Alan D. Criado ( (no email) )
Mon, 22 Feb 1999 21:00:31 -0500

Thank you Sheryl for your suggestion. I tried to do as you described, but
it still doesn't work. The report that is on your FTP site (SERV_REV.RPT)
seems like it will do what I need and I desparately need to get this working.

Any help would be greatly appreciated.

Thank you.

Alan D. Criado

At 05:01 PM 2/22/99 -0800, you wrote:
>Hi Alan,
>
>I removed all of the double quotes from the query you list below and
>replaced the "?" with the start and end date of the query. It then ran
>properly. I'm not sure what is causing the other errors, but it's the quotes
>and the variables that are screwing you up in ISQL_w.
>
>Sheryl D. Stover - sds@iea-software.com - http://www.iea-software.com
>IEA Software Account Management and Customer Service
>Phone: (509) 444-2455 ext. 51 - Fax: (509) 624-9903
>Billing and Customer Care for ISPs and Communications Companies
>
>-----Original Message-----
>From: Alan D. Criado <ACriado@elink.net>
>To: emerald@iea-software.com <emerald@iea-software.com>
>Date: Monday, February 22, 1999 1:53 PM
>Subject: RE: [Emerald] Labels & Reports
>
>
>:
>:
>:Hello Dale.
>:
>:I'm running Emerald 2.5.22.
>:
>:Whenever I try to run the SERV-REV.RPT report, I get an SQL error:
>:
>:ODBS error: [Microsoft][ODBC SQL Server Driver][SQL Server]The number '0.'
>:is out of the range for numeric representation [max precision:33].
>:
>:If I just try to run the SQL Query of that report:
>:
>:SELECT
>: Invoices."Type", Invoices."Date",
>: InvoiceItems."Login", InvoiceItems."Description",
>:InvoiceItems."Amount", InvoiceItems."Tax", InvoiceItems."Quantity",
>:InvoiceItems."Tax2"
>:FROM
>: { oj "Emerald"."dbo"."Invoices" Invoices INNER JOIN
>:"Emerald"."dbo"."InvoiceItems" InvoiceItems ON
>: Invoices."InvoiceID" = InvoiceItems."InvoiceID"}
>:WHERE
>: Invoices."Type" <> 'VOID' AND
>: Invoices."Date" >= ? AND
>: Invoices."Date" <= ? AND
>: InvoiceItems."Amount" > 0.
>:ORDER BY
>: InvoiceItems."Description" ASC
>:
>:I get the following error message as the results:
>:
>:Msg 170, Level 15, State 1
>:Line 2: Incorrect syntax near 'Type'.
>:Msg 1007, Level 15, State 1
>:The number '0.' is out of the range for numeric representation (max
>:precision: 33).
>:
>:
>:Do you have any idea what could be wrong and how to correct this?
>:
>:Thank you for your assistance.
>:
>:Alan D. Criado
>:
>:For more information about this list, including removal,
>:please see http://www.iea-software.com/maillist.html
>
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html
>

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html