Simple
steps for developing SSRS Report
Steps to build Simple SSRS Report:
1)
Create New Project with choosing Business Intelligence
Projects\ReportServerProject.
2)
By opening this Simple Report Project, click on Solution Explorer View. You are
able to see following screen.
3) Now Right click on Shared Data Sources folder and choose
Add New Data Source tab to add the Data Source for report.Write the appropriate
connection string like following:
You
can choose the database connection string from Edit Button displayed on above
screen. Pressing Edit Button will redirect you on the following screen.
Choose the appropriate data base
name and server name and if Test Connection is Succeed
then Press OK button. This will reflect to Shared Data Source connection string. It will be
automatically changed as per you selected in Connection Tab.
then Press OK button. This will reflect to Shared Data Source connection string. It will be
automatically changed as per you selected in Connection Tab.
5)
Now
turns to add report to our Report Server Project. Let’s create a sample report,
which can display the Employee Details like First Name, Last Name, Address,
City, Region, Country, etc.
For all
this we need to add a report first, so for this right click on “Report” Folder
in The Simple Report Project and choose “Add” Then “Add New Item” you can see
the following screen:
Choose “Report” and give appropriate
report name and click on ADD button.
6)
After adding a new report into project, you will be able to see tree tabs.
a. Data – You have to provide the dataset for the report
into this option. You can specify the SQL script into that.
b. Layout – This tab handle the layout of the report. You
can specify the report layout in design mode. This works same as Report
designers like Crystal report etc…
c. Preview – You can see the Preview of the report in this
tab.
In Data
tab User will need to create dataset for the report. The Dataset dropdown will
have option by using this User will be able to create the dataset.
For this
in DATA Region of the Report, click on Item of the Data Set Drop Down List Box.
By clicking this you are redirected in following screen.
Here you
have two options:
- Write SQL Queries directly by selecting Command Type=”TEXT”
- You can give Stored Procedure Name also by selecting
the Command Type=” StoredProcedure”.
Press ok after applying proper queries or stored procedure depends as per requirements.
Following diagram shows the Data tab
of the Report.
7)
Now turns to design the Actual
Report as per our needs.
We want to display the Employee
Details in our report. For this we are required to put
Labels, Text Boxes that shows the actual details of the Employees from the Employee table
as we applied into the Data Region.
Labels, Text Boxes that shows the actual details of the Employees from the Employee table
as we applied into the Data Region.
Following image is showing the
Layout view of the report in this we are using Table
object,which have the facilities of Header and Footer of the Rows. So we are displaying the
Column Title in Header and the actual record in Rows section of the Table.
object,which have the facilities of Header and Footer of the Rows. So we are displaying the
Column Title in Header and the actual record in Rows section of the Table.
8)The stored procedure will returns the dataset. The dataset’s
column names will be displayed in Report Data Explorer. You can use datasource
as dataset or stored procedure. If you
used dataset,the datasets column name would be listed. Here the stored
procedure passed with parameters.
