Reporting Tip: Dynamically changing font on run time for Dynamics NAV

Introduction :

Hey!

Don’t we fix the font size of our text box in NAV report ? Will it not be cool if we could dynamically change it?

This article  is a quick tip where we can dynamically change the font size of the text on run time based on the length of the text.

Pre-requisites :

• Microsoft Dynamics NAV
• SQL server Report Builder

Steps:

1. Open your development environment and launch your SQL Server Report Builder.
2. Select your textbox and open the textbox properties.

3. Click on font and then click on expression and type your expression

This expression =iif(Len(Fields!No_Item.Value) < 12, “60pt”,”48pt”) 

says if the length of the field is less than 12 then font size of the textbox will run as 60pt otherwise its 48pt.

Happy Weekend!