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.
