December 22, 2011 at 2:46 pm
In SSRS 2008, how do I code an expression to control the font size depending on the length of a text field?
December 22, 2011 at 3:24 pm
=iif(len(value) > x, "8pt","10pt")
Or am I misunderstanding your needs?
December 22, 2011 at 3:24 pm
Turns out I was close ... just needed double quotes around the THEN and ELSE parameters.:-)
=iif(Len(Fields!AGENCYNAME.Value)<40,"10pt","8pt")
December 22, 2011 at 3:26 pm
Thank you, 'Journeyman'.
No; you understood perfectly and your answer was exactly what I needed.:-)
December 22, 2011 at 3:29 pm
Excellent!
Glad you got it up and running.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply