HTML Web Design Tutorial: Create a Basic Table Report

Create a Basic Table Report

Create a Basic SSRS Table Report

This tutorial is designed to help you create a basic table report based on the Adventure Works database using Report Designer. You can also use Report Builder or the Report Wizard to create reports. In this tutorial, you will create a report project, set up connection information, define a query, add a Table data region, group and total some fields, and preview the report.

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.

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.

Create a Basic Table Report

Create a Basic SSRS Table Report

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.

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.

Share this

Related Posts

Step 3:
Next we need to create a Dataset.
In the Report data tab, right click on Datasets and complete the wizard.

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 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.