Format Table Report in SSRS

In this article we will show you, How to Format Table Report in SSRS. It includes changing the Font Style, Font Color, Font Family, Font Size, Font Weight, and Background Color of a Table Report in SQL Server Reporting Services with example.

To explain the available Format options, We are going to use below shown Data Set. Please refer Shared Data Source and Dataset articles to understand the steps involved in creating Shared Data Source, and Dataset that we used for this report.

and the Custom SQL query that we used in the above Data set is:

SQL Query

-- Format SSRS Table Report
SELECT Prodcat.EnglishProductCategoryName,
       prodSubcat.EnglishProductSubcategoryName,  
       prod.EnglishProductName, 
       prod.Color, 
       fact.[TotalProductCost],
       fact.SalesAmount, 
       fact.TaxAmt,
       fact.[OrderDate],
       fact.[ShipDate] 
FROM dbo.DimProduct as prod 
  INNER JOIN 
dbo.DimProductSubcategory AS prodSubcat ON 
       prod.ProductSubcategoryKey = prodSubcat.ProductSubcategoryKey 
  INNER JOIN  
dbo.DimProductCategory AS Prodcat ON 
       prodSubcat.ProductCategoryKey = Prodcat.ProductCategoryKey 
  INNER JOIN  
dbo.FactInternetSales AS fact ON 
       fact.ProductKey = prod.ProductKey
WHERE SalesAmount >= 3500

To explain the Formatting options available in SSRS, We are going to use below shown report. Please refer SSRS Table Report article to understand the steps involved in creating Table Report, and refer Grouping in SSRS Table Report article to understand the Grouping.

If you observe the below screenshot, It was just a normal report with Product Category Name (Main Group), Product Subcategory Name (Sub Group), Product Name, Color, Total Product Cost, and Sales Amount columns as Details.

Let me show you the table Report Preview.

If you observe the above screenshot, it is displaying the perfect result, but I must say that the data presentation is awful.

Format Table Report in SSRS

Please Hold the Ctrl Key (if you are on Windows) select all the Columns, and go to the properties window as we shown below. It allows us to format all the Rows, and Columns present in the Table Report.

Format Fonts of a Table Report in SSRS

Please navigate to the Font section within the properties window, and expand it to see the available properties

First we will change the Font family of the total report. To change the Font Family, Go to FontFamily Property and change the font as per your requirement. Here we are changing the Font of a Header Text and Details Row to Cambria.

Format Header Row of a Table Report in SSRS

In order to format the Header row (Column Headers), Please select the Header Row and go to the Properties as shown in below screenshot. First, let me change the Font size to 12pt

You can use the Font Style property to change the Default font style to Italic

You can use the Font Weight property to change the font to Bold, thin, normal, extra light, semi bold, extra bold, heavy, light etc. Here we are changing the Font weight to Semi Bold.

Format Header Row Background of a Table Report in SSRS

To change the Background color, Go to BackgroundColor Property and select the required color. Here we are selecting Turquoise

Format Detail Row of a Table Report in SSRS

In order to format the Detailed row (All rows except Column Headers), Please select the Detailed Row by selecting the corner, and go to the Properties as shown in below screenshot. Let me change the Font size to 11pt

Let us preview the formatted SSRS Table report

If you observe the above screenshot, It looks neat and clean

Thank You for Visiting Our Blog