Crystal Reports Troubleshooting

I got around this on a report with different needs by creating a
subreport to total my MISC items.



Bruce Butler

IT Manager

Knappe & Koester, Inc.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of fselliott_tech
Sent: Wednesday, September 19, 2007 12:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Troubleshooting



I am trying to write a report that has multiple miscellaneous charges
on the line. If Line 1 has 3 miscellaneous charges (or three SeqNum,
then all the information for Line 1 is repeated 3 times to match the
charges. This, of course, causes problems when I subtotal the Book
Value column. I have tried to join differently, supress, use a sum
calculation, but have not had any success in pulling in the 3
miscellaneous charges as a total on the Line 1. The tables I am using
are BookDtl, OrderMsc, OrderDtl, and Customer. I have grouped by
Product Code, then Type, then order #. Can anyone offer any advice?
Thanx!





[Non-text portions of this message have been removed]
I am trying to write a report that has multiple miscellaneous charges
on the line. If Line 1 has 3 miscellaneous charges (or three SeqNum,
then all the information for Line 1 is repeated 3 times to match the
charges. This, of course, causes problems when I subtotal the Book
Value column. I have tried to join differently, supress, use a sum
calculation, but have not had any success in pulling in the 3
miscellaneous charges as a total on the Line 1. The tables I am using
are BookDtl, OrderMsc, OrderDtl, and Customer. I have grouped by
Product Code, then Type, then order #. Can anyone offer any advice?
Thanx!
How are you grouping the report. Use OrderHed & OrderDtl as the groups. Do
not put everything in the Detail line just the MscCharge Field. Put the
OrderNum, OrderLine fields in the Order Line Group. Then the Misc Charges
for the each line will show just for that line.

I had the same issue for some Sales Reporting from Invoice and after trying
a subreport (which worked but was slow) it dawned on me to pull the Misc
Charge detail by Invoice Line.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
fselliott_tech
Sent: Wednesday, September 19, 2007 11:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports Troubleshooting

I am trying to write a report that has multiple miscellaneous charges
on the line. If Line 1 has 3 miscellaneous charges (or three SeqNum,
then all the information for Line 1 is repeated 3 times to match the
charges. This, of course, causes problems when I subtotal the Book
Value column. I have tried to join differently, supress, use a sum
calculation, but have not had any success in pulling in the 3
miscellaneous charges as a total on the Line 1. The tables I am using
are BookDtl, OrderMsc, OrderDtl, and Customer. I have grouped by
Product Code, then Type, then order #. Can anyone offer any advice?
Thanx!



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
Yahoo! Groups Links
Thank you!! I added a formula to the Section to suppress blank
(empty) line values: ISNULL({OrderMsc.MiscAmt}) or {OrderMsc.MiscAmt}
= 0

It looks great!!

--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...>
wrote:
>
> How are you grouping the report. Use OrderHed & OrderDtl as the
groups. Do
> not put everything in the Detail line just the MscCharge Field. Put
the
> OrderNum, OrderLine fields in the Order Line Group. Then the Misc
Charges
> for the each line will show just for that line.
>
> I had the same issue for some Sales Reporting from Invoice and
after trying
> a subreport (which worked but was slow) it dawned on me to pull the
Misc
> Charge detail by Invoice Line.
>
> Scott
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> fselliott_tech
> Sent: Wednesday, September 19, 2007 11:48 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Reports Troubleshooting
>
> I am trying to write a report that has multiple miscellaneous
charges
> on the line. If Line 1 has 3 miscellaneous charges (or three
SeqNum,
> then all the information for Line 1 is repeated 3 times to match
the
> charges. This, of course, causes problems when I subtotal the Book
> Value column. I have tried to join differently, supress, use a sum
> calculation, but have not had any success in pulling in the 3
> miscellaneous charges as a total on the Line 1. The tables I am
using
> are BookDtl, OrderMsc, OrderDtl, and Customer. I have grouped by
> Product Code, then Type, then order #. Can anyone offer any advice?
> Thanx!
>
>
>
> 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
> Yahoo! Groups Links
>
One of our Sales Reps is getting an error 138 in
Vantage when trying to work on a particular customer
in Customer Maintenance (V 6.1). It says something
like "Customer Contact Not On File", but it is on
file.

Any ideas?

Thanks.
Dwight Jones
IRP, Inc.


____________________________________________________________________________________
Check out the hottest 2008 models today at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html