Calculated field in report builder to print first word of fiel

Yahoo Archive
1
Is there a way to prevent payments for a product that has been already paid
for through Advance Billing?

We issued a PO and made Advance payment. Then, after shipping the product to
us, Supplier sent an invoice which AP Clerk entered as Receipt Billing Line.
Eventually, the invoice was paid in addition to the Advance Payment. Any
idea how to stop it? We run V3.0.

Thank you.

Vladimir Tigay



[Non-text portions of this message have been removed]
2
Something like SUBSTRING(Field-X,1,INDEX(Field-X,' ') ought to work I think.
-Todd C.

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, October 22, 2002 12:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculated field in report builder to print first word of
field only


Does anyone know of an equation in Report Builder to make a calculated field
print only the first work of a field, regardless of word lenth?

i.e. "Lilly Turbo" will be "Lilly", "NP Medical Valve" will be "NP"


Yahoo! Groups Sponsor

ADVERTISEMENT

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

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

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]