concatenate formula

[rhoneyfi]

Hello,
I am contatenating 2 fields together like this:

[field1] & chr(13) & [field2]

What I would like is for [field1] to be formatted in a font size slighly bigger than [field2]. Worst comes to worst, I would like [field1] to at least be in Bold and [field2] be non-bold. Thanks

 

[bdreed35]

Create a text object on your report that would span 2 lines.
Drag each field from the Report Explorer into the text object, seperating the 2 by htiing the Enter key. They should be on seperate lines of the text object now.
Double Click the first field in the text object, Right click it when it becomes highlighted, and choose Format..(the field Name).
Format it as necessary.
Do the same thing for the second field.

You can also accomplish the same thing by placing the 2 fields on the report seperately and formatiing them independently.

~Brian

 

[rhoneyfi]

I am doing a crosstab (non-manual) and this concatenation is going in the "Row 2" portion. For a normal report, I could use your suggestion, but not for the crosstab. Any other advice??? Thanks

 

[bdreed35]

You could create a formula field and then set the text interpretation to HTML.

The contents of your formula would be this:

&quot;<Font size=3>&quot; + {field1} + &quot;</Font><br />&quot; + 
&quot;<Font size=2>&quot; + {field2}  + &quot;</Font>&quot;

Once you place the formula on the report, Right Click it, Choos Paragraph Formatting, and Change Text Interpretation to HTML Text.

The limitations here are that you can only use font sizes that you have available to you in HTML.

~Brian

 

[mbarron]

You can use the following as your formula. It will make field1 slightly larger than field 2. If you want to make the field bold add the <strong> tag in blue

&quot;<font size=3><strong>&quot; & {field1} & &quot;</strong></font>&quot; &&quot;<p>&quot; & &quot;<font size=1>&quot;&{field2} & &quot;</font>&quot;

After you put it in your report, right click on the field and choose &quot;Can Grow&quot; on the Common tab. Then on the Paragraph tab, change the Line Spacing to &quot;multiple of&quot; and use .5 and in the Text interpretation, choose HTML.

Mike