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 Table Textbox in SQL Server Reporting Services with an example.
To explain the available Format options, We are going to use the below-shown report. Please refer to the Table Report article to understand the Shared Data Source and Dataset we used for this SSRS report.
If you observe the below screenshot, It was a regular report with Product Name, Color, Sales Amount, and Tax Amount columns.
If you observe the above screenshot, it is displaying the correct data but not attractive to impress the end-user.
Format Fonts and Background Color of a Textbox in SSRS
To Format Fonts and Background Color of a Textbox in SSRS Table, Please select the Header Row and go to the Properties as shown in below screenshot
Format Background Color of a textbox in SSRS
To change the Background color, Goto BackgroundColor Property and select the required color. Here we are selecting CornflowerBlue
Format Font Color of a textbox in SSRS Table
To change the font color, Goto Font Color Property and select the color needed. Here we are leaving the Default Black color
Format Font Size of a SSRS textbox Table
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 Textbox Font Style in SSRS Table
To change the Font Style, Goto FontStyle Property, and change the font style as per your requirement (Normal, Italic). Here we are leaving the Default
Format Textbox Font Family in SSRS Table
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.
Let us preview the formatted report
If you observe the above screenshot, It looks neat and good