[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1840
  • Last Modified:

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?
0
holemania
Asked:
holemania
  • 2
2 Solutions
 
JestersGrindCommented:
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
 
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now