Blog

Reporting Services – Display data in a Table in SSRS

  • (4.0)
  •   |   430 Ratings

Display data in a table

The most basic way to display information on a report is to use a simple table. You create a table by simply dragging it from the toolbox and placing it on the page.

Learn how to use SSRS, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll for Free SSRS Training Demo!

The toolbox is usually on the left side of the screen, but it may be hidden by the Report Data panel. Depending on how your screen is set up, the Toolbox tab might be visible at the bottom or the left of the screen. If you can’t see it, use CTRL-ALT-X to display it.

Related Page: Format The Table In Reporting Services In SSRS

Tables come with a header row and a data row, and by default they have three columns. If you click into a table cell, the table gains a set of grey boxes around the top and left sides. These are similar to the column and row selectors in Microsoft Excel.

If you click onto the small grey box at the top left of the table (the very left of the header rows) the table will display handles that let you resize or move it on the report design surface.

Try it

1. Open the Toolbox if it is not already open. If the toolbox is not visible, use CTRL-ALT-X to display it.

2. From the Toolbox, drag a table on to the empty report, roughly in the centre of the report design surface.

3. The table has a Header row and a Data row. From the Report Data panel (you may need to click on a tab to open this if you pinned the toolbox open), drag the Month field from Datasets > SalesSummary into the first cell in the data row of the empty table. Note that the Header row is filled in automatically.

Frequently Asked SSRS Interview Questions & Answers

4. Now use an alternate way of filling the table. Hover your mouse over the empty data cell to the right of the Month cell and look for the field chooser icon. Click it, and select Total.

The report should look like this:]

To preview the report, click on the Preview tab at the top of the report window. After a couple of seconds, your basic report should be displayed. Note two things, however:

1. The month is displayed as a number. 
2. The sales total is displayed with four decimal places and no thousands separator. We’ll fix this soon.

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

 


Popular Courses in 2018

Get Updates on Tech posts, Interview & Certification questions and training schedules