How to Conditionally Reduce font of report data 1

[johneydluca]

HI
I have a small problem, i m sure some of you must have had the similar problem. I am formatting a report field. SO in case if the text is larger then field width i specify in report it wraps the text and goes to next line.
Instead i want to check the text programetically for the length, and if length is larger then specified size then i want to reduce the font size by 2 points or so.
Can anyone please help me in this regards.
Thanks in advance

Johney

 

[lyanch]

Right click on the field and select font. Click on the button x-2 by the size selection. Then add something along the line of

if length({yourfield}) > 20 then 8 else 12

That should do it.

Lisa