• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1891
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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