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