We have done this for several clients with the same scenario. Basically,
change the groups to group on invoice number, then part number. Put
information into the part header and footer as applicable, and create
sub-total/summary fields for applicable fields (i.e. ext price, etc.).
Depending on what information you need/don't need to print, it can be rather
straight forward or rather tricky, but definitely can be accomplished.
Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
www.intelligentsi.com
"Helping Business Make Intelligent Use of Technology"
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Tuesday, August 20, 2002 8:50 AM
To: Vantage User Group on Onelist (E-mail)
Subject: [Vantage] Crystal Invoice Form Modification
I ship 75,000 fasteners to a customer from 3 bins or three lots.
My invoice form prints 3 line items which makes no sense to my customer.
How do I sort & group on Part Number, Revision & Price and print a summary
line instead of the current line on a crystal invoice form?
Patrick Winter
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
change the groups to group on invoice number, then part number. Put
information into the part header and footer as applicable, and create
sub-total/summary fields for applicable fields (i.e. ext price, etc.).
Depending on what information you need/don't need to print, it can be rather
straight forward or rather tricky, but definitely can be accomplished.
Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
www.intelligentsi.com
"Helping Business Make Intelligent Use of Technology"
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Tuesday, August 20, 2002 8:50 AM
To: Vantage User Group on Onelist (E-mail)
Subject: [Vantage] Crystal Invoice Form Modification
I ship 75,000 fasteners to a customer from 3 bins or three lots.
My invoice form prints 3 line items which makes no sense to my customer.
How do I sort & group on Part Number, Revision & Price and print a summary
line instead of the current line on a crystal invoice form?
Patrick Winter
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/