Number fields concat to text "," problem 2

[ljsmith91]

I am new to CR. I have just installed CR XI. One nuisance issue I cannot figure out is:

I have 2 SQL Numeric fields that I want to combine into a single text CR field string on the report with a decimal point.

Field1 = 6732
Field2 = 02

I want to create a new field on the report that looks like this:

Newfield = 6732.02

I add a CR text field to the report and use the text editor to add this to the field :
{Field1}.{Field2}

But when I do, I get this value "6,732.02".

How do I format my formula so it comes out "6732.02"? Thanks for any help.

 

[rrgkanth]

Hi,

it's simple.
In your text field,
right click field1
Format Field1

In the format editor,
select number format as -1123.

I think that shd work.

-rrgkanth.

 

[ljsmith91]

rrgkanth,

Thanks for the reply.

I wasn't adding Field1 to the report so it's not that simple. Instead I am adding a new text Field Template and then editing that template so that it has a
value of {Field1}.{Field2}

When you right click the new text field, you do not have the option to FORMAT FIELD, only to FORMAT TEXT. So it doesnt think its a number but a text field and I do not have the option to change the type of numeric.

Any other suggestions to doing it this way? Thanks.

 

[chinjk]

How about creating a formula like this:

{field1}&'.'&{field2}

 

[rrgkanth]

Hi,

I understood that u didnt add the field to the report but to the text field.

you can go into edit mode of the text field (doubleclick), highlight field1, rightclick it and do as mentioned in my prev post.

 

[ljsmith91]

Thanks...both tips very helpful.