Phone Numbers on Sales Order

Yahoo Archive
1
Sharon -

Put both fields on the report on on top of the other. Then set up
suppression based on the length of the field returned from customer
contact.

HTH,
Calvin


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of skemper2
Sent: Monday, June 13, 2005 5:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Phone Numbers on Sales Order


Has anyone added the Purchasing and Shipping Phone numbers to the
SOFORM/Sales Order Acknowledgement in Crystal? I'm looking for
samples or advice. Since they're not stored in the OrderHed file, it
is getting complicated.

I started with subreports to add the phone numbers from the Customer
and CustCnt databases, put both on the report, and suppressed one or
the other based on if there is a contact number in the OrderHed. but
it doesn't account for null values in the phone number field. Is there
a better way to do this?

Now I know why they didn't include phone numbers in the first place!
Thank you
Sharon O'Neal
Conestoga Log Cabins, Inc.





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
2
Has anyone added the Purchasing and Shipping Phone numbers to the
SOFORM/Sales Order Acknowledgement in Crystal? I'm looking for
samples or advice. Since they're not stored in the OrderHed file, it
is getting complicated.

I started with subreports to add the phone numbers from the Customer
and CustCnt databases, put both on the report, and suppressed one or
the other based on if there is a contact number in the OrderHed. but
it doesn't account for null values in the phone number field. Is there
a better way to do this?

Now I know why they didn't include phone numbers in the first place!
Thank you
Sharon O'Neal
Conestoga Log Cabins, Inc.