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.
