BAQ Calculated Fields

Yahoo Archive
1
String(JobHead.JobNum) + “ “ + String(OrderHed.OrderNum)

?

Just guessing here

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Monday, March 21, 2011 8:46 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ Calculated Fields



Great thanks.

Do you know how I might be able to get a space in between them?

________________________________
From: Karen Schoenung <kschoenung@...<mailto:kschoenung%40fisher-barton.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Mon, 21 March, 2011 13:26:09
Subject: RE: [Vantage] BAQ Calculated Fields


Per Answer book # 3643ESC, concantenate looks like you need "+"

String(JobHead.JobNum) + String(OrderHed.OrderNum)

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Chris Thompson
Sent: Monday, March 21, 2011 8:02 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ Calculated Fields

Hi All

I want to try and create a calculated field which will combine the data from two
cells.

if isNull(JobHead.JobNum) then OrderHed.OrderNum else < This bit works ok
String(JobHead.JobNum) & String(OrderHed.OrderNum) < This doesnt work

I want the outcome to be 01264789 998877 ...

Where 01264789 is the JobNum and 998877 is the OrderNum.

They dont even need a space inbetween, it could just be one long string.

Does anyone know how to join the two field's output together?

Thanks.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
Is it not possible to use a CharacterXX field in a calculation formula in a
BAQ? I am trying to create a field that concatenates a ShortCharXX field
with a CharacterXX field. When I do that, my BAQ returns no results. Is
there a way I can cast the CharacterXX field to a shortchar to make this
work?



Daniel





[Non-text portions of this message have been removed]
3
Try converting the two fields or use variables and then calculate on the
variables. For example if using Crystal make a new Formula and using
Crystal syntax do the following:
Global NumberVar myVar1
Global NumberVar myVar2

myVar1 = ShortCharFieldXX
myVar2 = CharacterFieldXX

myVar1 + myVar2

OR try converting like this in a formula:
CDbl(ShortCharXX) + CDbl(CharacterXX) for numbers, use CStr for strings,
CCur of currency, and CDate for Dates.

________________________________

From: Daniel Laidig [mailto:daniellaidig@...]
Sent: Thursday, October 02, 2008 9:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Calculated Fields



Is it not possible to use a CharacterXX field in a calculation formula
in a
BAQ? I am trying to create a field that concatenates a ShortCharXX field
with a CharacterXX field. When I do that, my BAQ returns no results. Is
there a way I can cast the CharacterXX field to a shortchar to make this
work?

Daniel

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
4
If you don't have it, go:

http://www.psdn.com/library/entry!default.jspa?categoryID=282&externalID
=1078&fromSearchPage=true

If that URL gets broken, go to www.psdn.com and search for "progress
language reference"

9.1c is the latest.

You can use things like TRIM(), LEFT(), etc in the BAQ Calc fields using
Progress syntax.

As someone else advised, it may be easier to concatenate your two fields
(of varying field-types) within Crystal as it's easier and more
intuitive.


Cheers,


Vic Drecchio
ERP Administrator

TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@...
Office: 336.668.4410 x3091
Mobile: 704.530.3092



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Daniel Laidig
Sent: Thursday, October 02, 2008 10:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Calculated Fields

Is it not possible to use a CharacterXX field in a calculation formula
in a BAQ? I am trying to create a field that concatenates a ShortCharXX
field with a CharacterXX field. When I do that, my BAQ returns no
results. Is there a way I can cast the CharacterXX field to a shortchar
to make this work?



Daniel





[Non-text portions of this message have been removed]


------------------------------------

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/linksYahoo! Groups Links
5
Thanks, this actually worked:



String(OrderDtl.shortchar01) + " " + String(OrderDtl.Character01)



The only disappointing thing is that it doesn't let me search that field in
a dashboard. When I use this combined field to search from, it just
displays all results. Kind of annoying.



Daniel

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vic Drecchio
Sent: Thursday, October 02, 2008 12:01 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Calculated Fields



If you don't have it, go:

http://www.psdn. <http://www.psdn.com/library/entry>
com/library/entry!default.jspa?categoryID=282&externalID
=1078&fromSearchPage=true

If that URL gets broken, go to www.psdn.com and search for "progress
language reference"

9.1c is the latest.

You can use things like TRIM(), LEFT(), etc in the BAQ Calc fields using
Progress syntax.

As someone else advised, it may be easier to concatenate your two fields
(of varying field-types) within Crystal as it's easier and more
intuitive.

Cheers,

Vic Drecchio
ERP Administrator

TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@ <mailto:vic.drecchio%40timco.aero> timco.aero
Office: 336.668.4410 x3091
Mobile: 704.530.3092

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Daniel Laidig
Sent: Thursday, October 02, 2008 10:04 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] BAQ Calculated Fields

Is it not possible to use a CharacterXX field in a calculation formula
in a BAQ? I am trying to create a field that concatenates a ShortCharXX
field with a CharacterXX field. When I do that, my BAQ returns no
results. Is there a way I can cast the CharacterXX field to a shortchar
to make this work?

Daniel

[Non-text portions of this message have been removed]

------------------------------------

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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
6
I would like to add BAQ Calc fields to the Supplier Tracker. These Calc fields are included in the Customization dataview as Hidden. I un-check the fields to include; however when I test the Tracker these fields are now included in the Tracker but with NO data.
Is this possible to accomplish?

Thank you in advance!
7
Hi Janet,

You don't have the ability to modify calculated fields in a default Epicor
report. You can only modify fields in BAQ Reports that you set up.

You'd have to go through the SDK to manipulate the modified fields in an
existing Epiroc Report.

--Sean



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
janettalalai
Sent: Wednesday, September 09, 2009 11:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Calculated Fields





I would like to add BAQ Calc fields to the Supplier Tracker. These Calc
fields are included in the Customization dataview as Hidden. I un-check the
fields to include; however when I test the Tracker these fields are now
included in the Tracker but with NO data.
Is this possible to accomplish?

Thank you in advance!





[Non-text portions of this message have been removed]
8
Hi All

I want to try and create a calculated field which will combine the data from two
cells.

if isNull(JobHead.JobNum) then OrderHed.OrderNum else     < This bit works ok
String(JobHead.JobNum)Â Â Â & String(OrderHed.OrderNum)Â Â Â Â Â Â < This doesnt work

I want the outcome to be 01264789 998877 ...

Where 01264789 is the JobNum and 998877 is the OrderNum.

They dont even need a space inbetween, it could just be one long string.

Does anyone know how to join the two field's output together?

Thanks.                                               Â




[Non-text portions of this message have been removed]
9
Per Answer book # 3643ESC, concantenate looks like you need "+"

String(JobHead.JobNum) + String(OrderHed.OrderNum)

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Monday, March 21, 2011 8:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Calculated Fields



Hi All

I want to try and create a calculated field which will combine the data from two
cells.

if isNull(JobHead.JobNum) then OrderHed.OrderNum else < This bit works ok
String(JobHead.JobNum) & String(OrderHed.OrderNum) < This doesnt work

I want the outcome to be 01264789 998877 ...

Where 01264789 is the JobNum and 998877 is the OrderNum.

They dont even need a space inbetween, it could just be one long string.

Does anyone know how to join the two field's output together?

Thanks.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
10
Great thanks.

Do you know how I might be able to get a space in between them?




________________________________
From: Karen Schoenung <kschoenung@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Mon, 21 March, 2011 13:26:09
Subject: RE: [Vantage] BAQ Calculated Fields

Â
Per Answer book # 3643ESC, concantenate looks like you need "+"

String(JobHead.JobNum) + String(OrderHed.OrderNum)

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Monday, March 21, 2011 8:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Calculated Fields

Hi All

I want to try and create a calculated field which will combine the data from two
cells.

if isNull(JobHead.JobNum) then OrderHed.OrderNum else < This bit works ok
String(JobHead.JobNum) & String(OrderHed.OrderNum) < This doesnt work

I want the outcome to be 01264789 998877 ...

Where 01264789 is the JobNum and 998877 is the OrderNum.

They dont even need a space inbetween, it could just be one long string.

Does anyone know how to join the two field's output together?

Thanks.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]