Split a combined text object

[RenaG]

I put together in a Text Object a {Group #1 Name} and another database field. The {Group #1 Name} field is a numeric field and I would like to format it to display without the comma seperator. I can't do that now that I have put it into a text object. Does anybody know how to split a combined text object? TIA!

 

[RenaG]

Add-on to my first question.

I just created another Text Object field and this time remembered to format the {Group #1 Name} before adding to the Text Object. It is a numeric field and I formatted it to display without the comma seperator. However, when I put it into the Text Object field, it lost it's formatting and has the comma seperator. Any suggestions on how to get it to display the way I want it in the Text Object field?

 

[MCuthill]

RenaG,

Try:
{@FormulaField}

ToText({Group #1 Name},0,"") & {Table.Field}

If you cannot used the Group #1 Name object in the formula, substitute the {table.field} which the Group is based on. The "{Table.Field}" in the above is the "Another database field" you mentioned above.

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[RenaG]

Hey Mike,

That worked. I couldn't use the group name itself. It wouldn't allow any values for the y and z parameters of the ToText function. But I did get it to work with the {table.field} the group is based on.

I would still be interested in knowing if there is a way to split a Text Object once it is put together because I have done this several times and it would be easier to split it than delete it and put the fields back on the report .

BTW - like your quote.

 

[lbass]

When you add items to a text box, there are two formatting options. If you double click on one field/formula in the box and select it and then right click, you will see two formatting options: text formatting and format text. If you choose "format text", you can format the number field.

-LB

 

[RenaG]

Hey LB,

You don't see those options when the field is a group field. The only options you have are Text Formatting and Format {Group #1 Name}. And neither one of those gives you the option to format the number field.

 

[lbass]

There is no reason to use the groupname field--just use the field your are grouping on directly.

-LB

 

[RenaG]

Yep, you're right!

~RLG