Hi
Â
To decrease the Length on Dash Boards & Reports use the Syntax in the calculated Field as
Â
Left({Part.PartDescription},30)
Â
30 - This would be the length of the string & can be increased or decreased.
Â
Thanks.
Â
To decrease the Length on Dash Boards & Reports use the Syntax in the calculated Field as
Â
Left({Part.PartDescription},30)
Â
30 - This would be the length of the string & can be increased or decreased.
Â
Thanks.
--- On Sun, 8/15/10, Len Hartka <len.hartka@...> wrote:
From: Len Hartka <len.hartka@...>
Subject: [Vantage] E9\ V8 -Trim Field in BAQ or BPM
To: vantage@yahoogroups.com
Date: Sunday, August 15, 2010, 6:34 PM
Â
Good Day:
RE: Trim Field in BAQ or BPM
Sun is implementing EPICOR 9, SQL (9.05.600B.2) with a 10/4 Go-Live
date.
Since our Part: Description can be 8-12 lines, I would like to Trim (
Truncate) it on Dashboards and report.
What is the syntax in BAQ and BPM?
In Excell it is: Mid( [cell],start-n,n-number of characters) or
Right([cell],n) or Left([cell],n)
len.hartka@...
<blocked::mailto:len.hartka@...>
Leonard C. Hartka, IT Director\ERP Manager
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@...
**************************************************************
Sun Automation Group
Celebrating More Than
20 Years of Service
to the Corrugated Industry
**************************************************************
This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]