SSRS Table Report

In this article, we will show you how to create an SSRS Table Report (without using Report Wizard in SQL Server Reporting Services) with a practical example.

Creating SSRS Table Report

After creating the New SSRS Project, We have three folders in the solution explorer, such as Shared Data SourcesShared Datasets, and Reports. Reports folder is enough to design a basic SSRS report.

SSRS Table Report 1

In the solution explorer, Right-click on Reports folder ->Add -> New Item

SSRS Table Report 2

It will open the Add New Item window with all the available options. Please select the Report option and rename it as per your requirements. In this SSRS Table Report example, We are renaming it as NEW SSRS REPORT.rdl

SSRS Table Report 3

Click on the Add button to create a Blank report, as shown in the below screenshot.

SSRS Table Report 4

If you don’t find the SSRS Toolbox, then press Ctrl+Alt+X or go to the View tab and select the Toolbox

SSRS Table Report 5

Drag and drop a table from the SSRS Toolbox to the Data region.

SSRS Table Report 6

In this example, we are using the already created Data Source and Dataset. Please refer to Embedded Data Source and Embedded Dataset article to check the data.

We can add the Column names to the SSRS Table report in two ways:

  • We can Drag the Column name from Report data to the Table Column.
  • When we click on a particular cell, it will open the context menu displaying available column names in that Dataset. We can select the required column from the list as shown in below screenshot
SSRS Table Report 7

We successfully created our first table report. Columns we selecting for our First report are: English Product Name, Color, Sales Amount, and Tax Amount (Renamed the TaxAmt).

SSRS Table Report 8

Click on the Preview button to see the SSRS Table report preview

SSRS Table Report 9