The array fields are too big for Crystal 8.5 to handle so you need to
truncate them before you can parse the data.
Contact Vantage Support and ask for 3604MPS "How to truncate a memo
field".
(I don't have it in electronic form anymore or I would have attached it
here. )
We have used this for Rep List and Rep Commissions and a couple other
memo/array fields.
A few words to the wise:
1. Use the Sysprogress login and password;
2. Do not take the database down but there must be NO users in the
table you are modifying.
3. This change must be done separately for your training database as
well
Good luck!
Phyllis
Message: 1
Date: Fri, 17 Mar 2006 15:45:50 -0500
From: "Bruce Butler" <bbutler@...>
Subject: Crystal & Epicor Arrays
Does anyone know how to get a Crystal 8.5 formula to parse out an field
array? Crystal keeps telling me it does not accept "blog" or "memo"
fields in a formula. Specifically, I am looking at the Machine table
and the hours array.
Bruce Butler, IT Manager
Knappe & Koester <http://www.knappe-koester.com/
<http://www.knappe-koester.com/> >
18 Bradco Street
Keene, NH
p. 603-355-1166
f. 603-355-2266
bbutler@...
[Non-text portions of this message have been removed]
truncate them before you can parse the data.
Contact Vantage Support and ask for 3604MPS "How to truncate a memo
field".
(I don't have it in electronic form anymore or I would have attached it
here. )
We have used this for Rep List and Rep Commissions and a couple other
memo/array fields.
A few words to the wise:
1. Use the Sysprogress login and password;
2. Do not take the database down but there must be NO users in the
table you are modifying.
3. This change must be done separately for your training database as
well
Good luck!
Phyllis
Message: 1
Date: Fri, 17 Mar 2006 15:45:50 -0500
From: "Bruce Butler" <bbutler@...>
Subject: Crystal & Epicor Arrays
Does anyone know how to get a Crystal 8.5 formula to parse out an field
array? Crystal keeps telling me it does not accept "blog" or "memo"
fields in a formula. Specifically, I am looking at the Machine table
and the hours array.
Bruce Butler, IT Manager
Knappe & Koester <http://www.knappe-koester.com/
<http://www.knappe-koester.com/> >
18 Bradco Street
Keene, NH
p. 603-355-1166
f. 603-355-2266
bbutler@...
[Non-text portions of this message have been removed]