Concat

[mission2java]

I placed two field on my report:
QuoteNumber and RevLevel.

I want to concatenate this on the report to say:
QuoteNumber.RevLevel

How do I do a simple Concat?

Please realize i am very new at this...

 

[mission2java]

Dope I spoke too soon..got it with &

Thanks,
Jon

 

[mission2java]

Wait...a problem...

I changed QuoteNumber field so that it displays without a .00 and same with revlevel. But when I created @OurQuoteNumber as:

{Proposals.QuoteNumber} & "." & {Proposals.RevLevel}

It still comes up as

18001.00.1.00

I want it to come up as:

18001.1

 

[vidru]

This should do it:

totext({Proposals.QuoteNumber},0,"") & "." & totext({Proposals.RevLevel},0,"")

-dave

 

[mission2java]

Dave,

Excellent that worked!

I've got a lot to learn.

Thanks very much.

Jon