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

Picture showing the sample table from which SSRS reports will be displayed

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

Picture showing selecting the Report Server Project from the visual studio installed templates

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

Picture showing the project structure of the Report Server Project in visual studio

Click to Enlarge

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

Picture showing the Add New Item menu for adding the new report

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

Picture showing the Report1.rdl file added in the 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)

Picture showing the Report Data window in the visual studio

Click to Enlarge

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

Picture showing the Add Data Source in context menu

Click to Enlarge

Data Source property window will appear

Picture showing the Data Source property window

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

Picture showing the data source added inside the Data Sources folder

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

Picture showing the table control dropped on the designer window

Click to Enlarge

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

Picture showing the dataset dropped on the table control

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.

Picture showing the context menu for building the project

Click to Enlarge

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

Picture showing the output of your first ssrs project

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Wednesday, August 17, 2011

Query/Feedback

Your Email Id

Subject

Query/Feedback	Characters remaining 250