I have been having the same problem. I contacted Epicor support. They have
a fix and some intructions they will e-mail you.
Warren Eddy
National Tube Form LLC
warren.eddy@...
-----Original Message-----
From:
qle@... [mailto:
qle@...]
Sent: Wednesday, September 13, 2000 7:43 PM
To:
vantage@egroups.com
Subject: [Vantage] Crystal Report Help, please.
I have been struggling with one simple report. I just want to have
a report showing how many units of each part have been ordered for
the last 8 months? We cannot count from Inventory because we are not
linking production to accounting yet.
I join 3 tables: Inv.Detail, Inv.Header and Customer, then pull out
part #, order quantity, customer name, invoicedate (with simple
condition), and most of all the sum of each part that have been
ordered.
I used Merant ODBC and it works fine in connecting to the database in
Crystal Report. However, at the end when click to preview the
report, I got a message:
"ODBC error: [MERANT][ODBC PROGRESS driver][Progress]** unable to
understand after--"Declare". (247)" Then, another message:
"Error detected by DLL."
I called Merant c/s and was told to
download some patch from Seagate CrystalRpt. I did and get the same
old problem.
I tried Progress Report Design and could not find the function Sum or
Subtotal for each part#. Any help in either Crytal Report or
Progress. I really don't care which one if any of them works out
well. Please help.
Thanks a whole bunch.
We no longer allow attachments to files. To access/share Report Files,
please go to the following link:
http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
In report builder, you need to group by part number,
then use the aggregate functions to get totals. If you
have any questions, let me know. If you are just
looking for totals, check out the sales analysis report
in the Accts Rec. area. You can select certain customers,
parts, etc. This gives you the number of items shipped by
a certain time range.
Tim Care
Electro Chemical Finishing
----- Original Message -----
From: <qle@...>
To: <vantage@egroups.com>
Sent: Wednesday, September 13, 2000 8:43 PM
Subject: [Vantage] Crystal Report Help, please.
>
> I have been struggling with one simple report. I just want to have
> a report showing how many units of each part have been ordered for
> the last 8 months? We cannot count from Inventory because we are not
> linking production to accounting yet.
>
> I join 3 tables: Inv.Detail, Inv.Header and Customer, then pull out
> part #, order quantity, customer name, invoicedate (with simple
> condition), and most of all the sum of each part that have been
> ordered.
>
> I used Merant ODBC and it works fine in connecting to the database in
> Crystal Report. However, at the end when click to preview the
> report, I got a message:
>
> "ODBC error: [MERANT][ODBC PROGRESS driver][Progress]** unable to
> understand after--"Declare". (247)" Then, another message:
> "Error detected by DLL."
>
> I called Merant c/s and was told to
> download some patch from Seagate CrystalRpt. I did and get the same
> old problem.
>
> I tried Progress Report Design and could not find the function Sum or
> Subtotal for each part#. Any help in either Crytal Report or
> Progress. I really don't care which one if any of them works out
> well. Please help.
>
> Thanks a whole bunch.
>