Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Python Programs
    • Java Programs

Format Table Report in SSRS

by suresh

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 SSRS or SQL Server Reporting Services with an example.

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

Format Table Report in SSRS 1

And the Custom SQL query that we used in the above Dataset is:

-- 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 Table Formatting options available in SSRS, We are going to use the below-shown report. Please refer SSRS Table Report article to understand the steps involved in creating Table Report and refer to Grouping in SSRS Table Report article to understand the Grouping.

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

Format Table Report in SSRS 2

Let me show you the table Report Preview.

Format Table Report in SSRS 3

If you observe the above screenshot, it is displaying the perfect result, but I must say that the data presented 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. 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

Format Table Report in SSRS 4

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 Table Report in SSRS 5

Format Header Row of a Table Report in SSRS

To format the Header row (Column Headers), Please select the Header Row. Next, go to Properties. First, let me change the font size to 12pt

Format Table Report in SSRS 6

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

Format Table Report in SSRS 7

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

Format Table Report in SSRS 8

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 Table Report in SSRS 9

Format Detail Row of a Table Report in SSRS

To format the Detailed row (All rows except Column Headers), Please select the Detailed Row by selecting the corner, and go to the Properties. Let me change the font size to 11pt

Format Table Report in SSRS 10

Let us preview the formatted SSRS Table report

Format Table Report in SSRS 12

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

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy