Line item total for Crystal quote form

Yahoo Archive
1
try this:

ToNumber({@extendedpriceformula})

Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...


-----Original Message-----
From: hawkkt [mailto:ktrapp@...]
Sent: Tuesday, April 23, 2002 12:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Line item total for Crystal quote form


Does anyone have a work around for adding a line item total to the
standard Crystal quote form? Looking to add a total by line item for
quantity * unit price.

According to the trainer in my Crystal Forms eLearning class
yesterday, this is not possible without creating a new Crystal form
from scratch. The quantity comes across as a string and he said he
knew of no way to convert to a number. He suggested I wait until the
5.2 rev.

I think I have tried all the type conversion functions I saw in
Crystal. Any help would be greatly appreciated by this Crystal
rookie.



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/
2
Does anyone have a work around for adding a line item total to the
standard Crystal quote form? Looking to add a total by line item for
quantity * unit price.

According to the trainer in my Crystal Forms eLearning class
yesterday, this is not possible without creating a new Crystal form
from scratch. The quantity comes across as a string and he said he
knew of no way to convert to a number. He suggested I wait until the
5.2 rev.

I think I have tried all the type conversion functions I saw in
Crystal. Any help would be greatly appreciated by this Crystal
rookie.
3
cdbl({quoteqty.QUANTITY})

I have line totals on my form using the above formula to convert the qty
field, Vantage 5.0, crystal 8.5.




[Non-text portions of this message have been removed]
4
More Specifically,

ToNumber ({quoteqty.QUANTITY}) * {quoteqty.UNITPRICE}

This works with the standard vantage 3 quote form.

Thaddeus Jacobs
Information Solutions Developer
Kinematic Automation, Inc.
mailto:tjacobs@...


-----Original Message-----
From: hawkkt [mailto:ktrapp@...]
Sent: Tuesday, April 23, 2002 12:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Line item total for Crystal quote form


Does anyone have a work around for adding a line item total to the
standard Crystal quote form? Looking to add a total by line item for
quantity * unit price.

According to the trainer in my Crystal Forms eLearning class
yesterday, this is not possible without creating a new Crystal form
from scratch. The quantity comes across as a string and he said he
knew of no way to convert to a number. He suggested I wait until the
5.2 rev.

I think I have tried all the type conversion functions I saw in
Crystal. Any help would be greatly appreciated by this Crystal
rookie.



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/