Friday, October 2, 2015

Format Fonts and Background Color of a Textbox in SSRS 2014



In this article we will show you, How to change the Font Style, Font Color, Font Size, Font Family, Font Weight and Background Color of a Textbox in SQL Server Reporting Services2014 with example.
To explain the available Format options, We are going to use below shown report. Please refer SSRS Table Report article to understand the Data Source and Dataset we used for this report. If you observe the below screenshot, It was a normal report with Product Name, Color, Sales Amount and Tax Amount columns.
Format Fonts and Background Color of a Textbox in SSRS 2014
If you observe the above screenshot, it is displaying the correct data but not attractive to impress the end-user.

Formatting Textbox Fonts and Background Color in SSRS 2014

Select the Header Row and go to the Properties as shown in below screenshot
Format Fonts and Background of a Textbox in SSRS 1
Background Color
To change the Background color, Goto BackgroundColor Property and select the required color. Here we are selecting CornflowerBlue
Format Fonts and Background of a Textbox in SSRS 2
Font Color
To change the Font color, Goto Font Color Property and select the required color. Here we are leaving the Default Black color
Format Fonts and Background of a Textbox in SSRS 3
Font Size
To change the Font Size, Goto FontSize Property and change the font size as per your requirement. Here we are changing it to 12pt
Format Fonts and Background of a Textbox in SSRS 5
Font Style
To change the Font Style, Goto FontStyle Property and change the font style as per your requirement (Normal, Italic). Here we are are leaving the Default
Format Fonts and Background of a Textbox in SSRS 6
Font Family
To change the Font Family, Goto FontFamily Property and change the font as per your requirement. Here we are changing the Font of a Header Text and Details Row to Lucida Sans. 
Format Fonts and Background of a Textbox in SSRS 7
Let us preview the report
Format Fonts and Background of a Textbox in SSRS 8
If you observe the above screenshot, It looks neat and good
Thank You for Visiting Our Blog