width formatting for a fromula field or text field

[unknownly]

Hi All,

I have drop the formula field/text field into the report and if the width of it is small and the value of the field is more than that of the field width it prints as cut off

ex: has a value
@ test1: Account Category:

But it prints only part of it in report because the width is small( prints as: Account Ca) is there anything like (tight horizontal for broder)not the can grow option.

Thanks,

Sweetie

 

[synapsevampire]

You can adjust the font size dynamically using:

Right click the field->Format Field->X 2 next to Font and use whatever criteria makes sense, as in:

if len({TABLE.FIELD}) > 4 then
8
else
10

You can also use HTML formatting for CR 8 and later, though the above is a cleaner approach.

-k

 

[unknownly]

Hi,

Iam using CR version 8. In format field there are 5 tabs
Iam using Font tab(3 tab) and next to font X+2

I using formula as you adviced.

if length({@field}) > 4 then
14

It gives me error : the formula result must be a string

so I changed the above condition to

if length({@field}) > 4 then
'14'

But it doesn't work.

Can you tell if iam doing it wrong.

Thanks for the help.

Sweetie

 

[lbass]

Try the following in the X+2 next to "Size"

if length(totext({@field},0,"&quot) > 4 then
8 else 10

-LB