How to Format a Table Report In SSRS

Formatting the table

Producing a functional table that displays basic data is quite straightforward, but displaying data straight from the database doesn’t always look very nice.

If you would like to become an SSRS (SQL Server Reporting Services) certified professional, then visit Mindmajix - A Global online training platform: "SSRS Training and Certification Course". This course will help you to achieve excellence in this domain.

The content of table cells can be formatted to make text appear bold, underlined, different size or font, etc. To select a cell for formatting, click the mouse pointer on an empty part of the cell while the pointer is still an arrow. If you click on the text contained within a cell, you might select the contents instead. This doesn’t always matter, but you will get different options available when you right-click.

If the cell gets a thick border, you’ll know you’ve selected the cell and not just its contents.

To set the font style and size attributes such as Bold and Italic, and colors used in the cell, you can either use the formatting toolbar at the top of the screen

Tool Bar

or select the cell and edit its properties in the Properties panel on the right of the screen. The Properties panel is visible by default, but if it’s been closed press the F4 key to display it.

Tip: You can give text boxes a meaningful name using Text Box Properties. Then this name will appear at the top of the Properties panel to either confirm that you have selected the correct item on the report or to allow you to select it from a list. This can be useful if the item you want to select is very small, or hidden behind something else.

Properties
MindMajix Youtube Channel

Try it

1. In the Design view, right-click on the empty data cell and choose Delete columns to remove the redundant column to the right of the data.

2. Click anywhere on the table to make sure the row and column selectors are displayed. These are the grey boxes that form a border to the left and above the table.

3. Select the Header row by clicking on the grey border to the left of the row. This should highlight both header cells with a thick border.

Month_Total

4. Use the Properties panel on the right of the screen to set the background of the header row to a light shade of blue. If the Properties panel is not visible, use the F4 key to display it.

5. Click onto an empty area of the report, outside of the table. This will make the Report menu visible at the top of the screen.

                                 Frequently Asked SSRS Interview Questions & Answers

6. Open the Report menu and choose to Add page header, and then from the Toolbox (click the tab if it’s not visible, or use CTRL-ALT-X) drag a Textbox on to the report, and position it in the header.

7. Click into the text box and type Sales Summary by Month.

8. Click away from the text box and then select it by clicking on its edge. Set the format of the text in the textbox using the formatting buttons on the toolbar. Make the text Bold and set the size to 20pt.

9. The positioning and sizing handles should still be displayed. if not, click on the edge of the text box again. Use the mouse to resize the text box as necessary.

10. Preview the report by clicking the tab at the top of the window.

Sales summary by month

Explore SSRS Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download Now!

 

List of Related Microsoft Certification Courses:

 SSIS Power BI
 SSAS SQL Server
 SCCM SQL Server DBA
 SharePoint BizTalk Server
 Team Foundation Server BizTalk Server Administrator

 

 

Job Support Program

Online Work Support for your on-job roles.

jobservice

Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:

  • Pay Per Hour
  • Pay Per Week
  • Monthly
Learn MoreGet Job Support
Course Schedule
NameDates
SSRS TrainingDec 07 to Dec 22View Details
SSRS TrainingDec 10 to Dec 25View Details
SSRS TrainingDec 14 to Dec 29View Details
SSRS TrainingDec 17 to Jan 01View Details
Last updated: 03 Apr 2023
About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read less