Reporting Services - Custom code to change font size

Does anyone know how I can change font size base on length of text file in textbox?  I have a need to shrink text file to fit a textbox.  I know that the textbox can be set to grow or shrink.  However, I need the textbox to stay static and not change, but the text can shrink.  

I know this can be done easily in Excel, but can't seem to get it working with Reporting Services 2005.  Any ideas or examples if anyone have any?
holemaniaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
JestersGrindConnect With a Mentor Commented:
You should be able to do it by using an expression for your font size, something like:

=IIF( LEN(Fields!FieldName.Value) > SomeValue, "8pt", "10pt" )

Greg

0
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
0
 
holemaniaAuthor Commented:
Thank you for the assistance.  We decided to leave reporting services as a reporting tool and not so much as what we can do in excel.  Since users are able to export it, they can do the few minor tweaks.
0
 
holemaniaAuthor Commented:
Decided not to go this route any more.  Report is modify to print in one page, and user can change formatting when export to excel.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.