Please help..someone with crystal problem

Mark,

Not really a magic fix, but perhaps another way to handle the problem...
Could you set up the Misc. charges as a subreport? I suggest this for two reasons. For one, the last Vantage Sales Order I did for a client worked this way...I can only assume there is a reason I did it like that. Secondly, Crystal has a tendency to return null results when it is working with null data - even if you accomodate for that in your formula.

i.e.
If Not(IsNull({SomeField}) Then
{SomeField}
Else
0

...and the formula returns a blank. I've had mild success with the 'Convert NULL to default' option under File, Options but it does not ALWAYS fix my problem.

--
Warm Regards,
Adam Ellis
Senior Consultant - SaberLogic, LLC
Ph: (330) 335-6442
Mobile: (330) 697-3883



Mark Howard wrote:

>Let me sta r t from the beginning
>
>I'm on Vantage 5.10.125 and using Crystal 8.0.1.0 and am having problem with
>Quotes, Another user suggested I download a dbexdrvrwin_en.zip file but it
>didn't help after I ran it.
>
>My problem is when a salesperson adds a miscellaneous charge the line price
>disappears off the Quote, it will show the comments for miscellaneous charge
>like " Freight - $150.00".
>
>On the footer of my report I have a Subtotal and the a GST line and then a
>Grandtotal in the report footer
>
>Subtotal = Sum ({@totalline})
>GST = {@grandtotal}*.1
>Grandtotal = {@gst}+{@grandtotal}
>
>I can add the miscellaneous charge to the subtotal by doing = Sum
>({@totalline}) + Sum ({LineMisc.MISCAMT})
>
>But can't seem to the miscellanous change to a line in the group header I
>tried
>(ToNumber ({quoteqty.QUANTITY}) * ToNumber ({@UnitPrice})) +
>{LineMisc.MISCAMT} but when I do this I get nothing and also the subtotals
>disappear to.
>
>I'm hoping this makes sence and someone can help me out with a formula or a
>copy of a quote that has Line total with miscellous charge added to it.
>
>Mark Howard
>Financial Controller
>Jaws Buckets & Attachments
>------------------------------------------------------
>This email, together with any attachments, is intended for the named
>recipient(s) only and may contain privileged and confidential information.
>No information within this email can be forwarded via email or verbally
>without the consent of the sender.
>
>If not an intended recipient of this email, you must not copy, distribute or
>
>rely upon it and any form of disclosure, modification, distribution and/or
>publication of this email is prohibited.
>
>Unless stated otherwise, this email represents only the views of the sender
>and not the views of Jaws Buckets & Attachments.
>
>
>
>
>
>
>
>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>Yahoo! Groups Sponsor
>
>ADVERTISEMENT
>
><http://rd.yahoo.com/M=237459.2482214.3917349.2240799/D=egroupweb/S=17050071
>83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
>300x250;ord=1037149548998998?>
>
><http://us.adserver.yahoo.com/l?M=237459.2482214.3917349.2240799/D=egroupmai
>l/S=:HM/A=1267611/rand=408686177>
>
>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/.
><http://groups.yahoo.com/group/vantage/files/.>
>(2) To search through old msg's goto:
>http://groups.yahoo.com/group/vantage/messages
><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
><http://groups.yahoo.com/group/vantage/links>
>
>Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
><http://docs.yahoo.com/info/terms/> .
>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>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/
>
>
>
>
>
Let me stat from the beginning

I'm on Vantage 5.10.125 and using Crystal 8.0.1.0 and am having problem with
Quotes, Another user suggested I download a dbexdrvrwin_en.zip file but it
didn't help after I ran it.

My problem is when a salesperson adds a miscellaneous charge the line price
disappears off the Quote, it will show the comments for miscellaneous charge
like " Freight - $150.00".

On the footer of my report I have a Subtotal and the a GST line and then a
Grandtotal in the report footer

Subtotal = Sum ({@totalline})
GST = {@grandtotal}*.1
Grandtotal = {@gst}+{@grandtotal}

I can add the miscellaneous charge to the subtotal by doing = Sum
({@totalline}) + Sum ({LineMisc.MISCAMT})

But can't seem to the miscellanous change to a line in the group header I
tried
(ToNumber ({quoteqty.QUANTITY}) * ToNumber ({@UnitPrice})) +
{LineMisc.MISCAMT} but when I do this I get nothing and also the subtotals
disappear to.

I'm hoping this makes sence and someone can help me out with a formula or a
copy of a quote that has Line total with miscellous charge added to it.

Mark Howard
Financial Controller
Jaws Buckets & Attachments
------------------------------------------------------
This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential information.
No information within this email can be forwarded via email or verbally
without the consent of the sender.

If not an intended recipient of this email, you must not copy, distribute or

rely upon it and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the sender
and not the views of Jaws Buckets & Attachments.











[Non-text portions of this message have been removed]
Let me sta r t from the beginning

I'm on Vantage 5.10.125 and using Crystal 8.0.1.0 and am having problem with
Quotes, Another user suggested I download a dbexdrvrwin_en.zip file but it
didn't help after I ran it.

My problem is when a salesperson adds a miscellaneous charge the line price
disappears off the Quote, it will show the comments for miscellaneous charge
like " Freight - $150.00".

On the footer of my report I have a Subtotal and the a GST line and then a
Grandtotal in the report footer

Subtotal = Sum ({@totalline})
GST = {@grandtotal}*.1
Grandtotal = {@gst}+{@grandtotal}

I can add the miscellaneous charge to the subtotal by doing = Sum
({@totalline}) + Sum ({LineMisc.MISCAMT})

But can't seem to the miscellanous change to a line in the group header I
tried
(ToNumber ({quoteqty.QUANTITY}) * ToNumber ({@UnitPrice})) +
{LineMisc.MISCAMT} but when I do this I get nothing and also the subtotals
disappear to.

I'm hoping this makes sence and someone can help me out with a formula or a
copy of a quote that has Line total with miscellous charge added to it.

Mark Howard
Financial Controller
Jaws Buckets & Attachments
------------------------------------------------------
This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential information.
No information within this email can be forwarded via email or verbally
without the consent of the sender.

If not an intended recipient of this email, you must not copy, distribute or

rely upon it and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the sender
and not the views of Jaws Buckets & Attachments.











[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2482214.3917349.2240799/D=egroupweb/S=17050071
83:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1037149548998998?>

<http://us.adserver.yahoo.com/l?M=237459.2482214.3917349.2240799/D=egroupmai
l/S=:HM/A=1267611/rand=408686177>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]