How to auto reduce font size if it is too long over fixed textbox in rdlc report

reporting-services rdlc rdl
Fame th picture Fame th · Sep 14, 2015 · Viewed 8.8k times · Source

My textbox have a some properties like these 

   txtBox.Cangrow = False

   txtBox.CanShrink = False

   Uncheck allow height to increase and decrease.

This textbox use for display value which receive from dataset. Sometime data is too long. So I need to know How to automatically decrease font size for matching with width of textbox?

Answer

Jonnus picture Jonnus · Sep 14, 2015

You'll need to manually determine which font sizes are required for stings of a certain length. You can then put an expression in the Font -> FontSize property as follows

=iif(len(Fields!myString.Value) > 20, "8pt", "10pt")

It's not possible to dynamically shrink the text to fit the textbox.

Related questions

When to use RDLC over RDL reports?

I have been studying SSRS 2005 / 2008 in the past weeks and have created some server side reports. For some application, a colleague suggested that I look into RDLC for that particular situation. I am now trying to get my head around …

Read More
SSRS tablix Merging cells vertically problem

I found the colspan and rowspan property defined in TablixCell,but in report Designer still can't vertical merge cells,if i modify the RDL xml file manually set Rowspan,the reportViewer show me error info:RowSpan must be 1 for CellContents …

Read More
Alternate rows background color in a group

I have following situation: Report with nested groups, whether group column has value 1 or 2. Next child group has 2 groups for each parent group, so for parent group 1 there is two child groups (1-1 and 1-3), and also for parent group 2 …

Read More