Crystal Report Help, please

Yahoo Archive
1
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.)
2
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.
>