Session 10: Creating a SSRS tabular report AnandFriday, December 19, 2014 0 comments

                     Session 10: Creating a SSRS Tabular Report

Creating SSRS tabular reports, is one of the simplest and easiest task.
Tabular reports implies, just simple data representation using tables.
SSRS makes creating tabular report super simple - just drag and drop data elements.
It gives you the ability to add totals etc, as we do in excel.

Lets look at some basic steps to create a SSRS tabular report.

Step 1:
Create an SSRS report server project.

Step 2:
Next add a blank report to your project.

Step 3: 
Next we need to create a Dataset.
In the Report data tab, right click on  Datasets and complete the wizard.
I am using Adventure works database for this demo.

Step 4: Add a query to get some data to your report.

Step 5: Now drag and drop a table control from the tool box (Left hand pane)

In the table control, drag and drop some fields from your dataset.

Once done, your Design pane should look something like this.

Step 6: Click on the preview tab, and you should be able to see a very basic tabular report.

Step 7: You could also add some totals to your report.
In order to add totals, right click on the cell where you would like to add the totals, click on 'Add Total'.
Click preview and you should be able to see a tabular report with totals.