Articles → SSRS → Creating your first SSRS report

Creating your first SSRS report

In this tutorial we will create a very basic SSRS report. In this report we will show the data of a table called employee which contains 3 columns Employee_Id, Employee_Name and City_Name (see the screen shot for reference).

Click to Enlarge

Now we will move forward step by step to create a SSRS report.

Create a new project

   a. Open Visual studio 2008

   b. Go to file menu

   c. Click new project

   d. A pop up window will come as shown in figure below

Click to Enlarge

   e. Select "Business Intelligence Projects"

   f. Select "Report Server Project"

   g. Give the name and location of the project click on "Ok".

A new project will be created

Add a new report in the project

When you create a new project three folders will be created

   1. Shared Data Sources

   2. Shared Dataset

   3. Reports

See the figure below

Click to Enlarge

Now to add a report right click on the "Reports" then click on Add – New Item as shown in figure below

Click to Enlarge

A pop up window will appear

Click to Enlarge

Select "Report" from visual studio installed templates and click add. A report will be added in "Reports" folder

Click to Enlarge

Select DataSource and DataSet

Not after we have added a report, to show the report we have to give data source and dataset.

Double click on "Report1.rdl" "Report Data" window will appear on the left hand side of IDE( If you are not able to see the window then click on View --> Report Data)

Click to Enlarge

Now right click on "Data Sources" Folder from report data and click on add datasource

Click to Enlarge

Data Source property window will appear

Click to Enlarge

Either you can give connection string or click on edit button to select the datasource. After you select the data source(or entered the connection string) click Ok. A datasource will be added as shown in figure below

Click to Enlarge

Now to add dataset right click on the datasets folder and click "Add DataSet".DataSet property window will appear.Select "Use a dataset embedded in my report" radio button and then select DataSource as DataSource1 and write a query

Click to Enlarge

Now click Ok.

Add controls on the report

To add control on the report click on view and then click Toolbox, a toolbox box will come. Drag a table control onto the report

Click to Enlarge

Now drag all the columns of dataset one by one onto the table and then click on save

Click to Enlarge

Build and run the report

Go to solution explorer and right click on the report. Click Build. After you got the build success message run the report by right click on the report.

Click to Enlarge

When you run the report you will get the following output.

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Wednesday, August 17, 2011

Query/Feedback

Your Email Id

Subject

Query/Feedback	Characters remaining 250