BAQ - Concatenate three fields?

Thanks Ted! It worked wonderfully.

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Hi,
>
>
> Syntax for inside the calculated field editor. These three fields must be part of the displayed fields and datatype of calculated field should be character.
>
>
> 'JobNum: ' + JobOper.JobNum + ' Asm: ' + String(JobOper.AssemblySeq) + ' Opr: ' + String(JobOper.OprSeq)
>
> Hope that helps,
>
> Ted
>
>
>
> ________________________________
> From: brucewbrannan <bruce.brannan@...>
> To: vantage@yahoogroups.com
> Sent: Friday, April 6, 2012 3:56 PM
> Subject: [Vantage] BAQ - Concatenate three fields?
>
> I want to create a Calcualted field in a BAQ; JobOper, AssemblySeq, OprSeq. Does anybody know the syntax to do so?
>
>
>
> ------------------------------------
>
> 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/.%c2%a0
> (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
>
>
>
> [Non-text portions of this message have been removed]
>
I want to create a Calcualted field in a BAQ; JobOper, AssemblySeq, OprSeq. Does anybody know the syntax to do so?
Hi,


Syntax for inside the calculated field editor. These three fields must be part of the displayed fields and datatype of calculated field should be character.


'JobNum: ' + JobOper.JobNum + ' Asm: ' + String(JobOper.AssemblySeq) + ' Opr: ' + String(JobOper.OprSeq)

Hope that helps,

Ted



________________________________
From: brucewbrannan <bruce.brannan@...>
To: vantage@yahoogroups.com
Sent: Friday, April 6, 2012 3:56 PM
Subject: [Vantage] BAQ - Concatenate three fields?

I want to create a Calcualted field in a BAQ; JobOper, AssemblySeq, OprSeq. Does anybody know the syntax to do so?



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

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/.%c2%a0
(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



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