Step by Step Creating SSRS report using wizard

This is a very basic and simple report of SSRS. Let’s start to create a first SSRS report using wizard.

Go to start button and select SQL server Business Intelligence Development studio (BIDS) and click it.

Click on File -> New -> Project

After clicking on the new project you will get the below screen.

A: - Select business intelligence project.

B: - select Reporting server project.

C: - Write the name of the project.

D: - Write the location where you want to save your project.

E: - Write the solution name.

F: - you can also select the location by clicking on browser button. Where you want to store the project.

G: - click ok

You will get the below screen

In solution Explorer you will get three folders.

Right click on Reports

Select Add New Report.

If you want to use shared data source click on the shared data source radio button.  For Wizard report it is not enabled.

A: - Write the name of the data source.

B: - select the data source type.

C: - Click on Edit

Write the server name and select the data base.

D: - If you want to make this data source as shared then click check box.

E: - For proving the credentials click on the button.

F: - Click on Next button.

Here you can write the sql query to fetch the data for report. For writing the query there is two way

1.       Using Query Builder

2.       Using Query String

Query Builder

Click on Query builder button

Click ok.

Otherwise you are free to write the direct query in Query string box.

Click on Next button.

You can generate the report in to two formats

1.       Tabular

2.       Matrix

Tabular Report

Click on next button.

Page: - select the page heading

Group: - select the group

Details: - select the fields which one you want to display in details.

Click on next

A: - select the layout of the report

 Stepped

Block

B: - If you want to show the sub total then check the Includes subtotals check box.

C: - If you want to enable drilldown option then check the Enable check box.

D: - Here you can see the preview of the report.

Click on next.

Here you can select the table style.

Click next.

Write the report name

Click Finish button.

Finally you will get the tabular report.

Matrix Report

Now I am going to see how to create the matrix report.

Click Next.

Select the page, columns, rows, details and click next button. Select the Matrix style.

Click Next

Write the report Name and click finish.

You will get the desirer Report.

Hope this article will be helpful to you. Waiting for you feedback.