In all organization Reporting is used either Crystal Report or SQL Server Reporting Service.Here we are going to discuss creation and use SQL Server Report.We can develop both static as well as dynamic report by using parameter.Generally we use stored procedure to create SQL Server Report.\
Before starting we should write a stored procedure which will used in data retrieving.
For developing SQL Server Report we have to follow following steps :
Step 1: Open Visual Studio.
Step 2: Click File ->New - > Project
Then you will get wizard having two columns :
a) Project Types & b) Visual studio Installed Templates
From project types choose Business Intelligence Projects from left side and choose Report Server Project Wizard.
Step 3: From Solution Explorer Right Click On Shared Data Source - >Add Shared Data Source
In this open wizard provide name of Shared Data Source and also provide connection strings.
Step 4: Now a blank panel will be open here you can use your own custom controls like table for rendering of data.
before attaching any control first we should create dataset.
Step 5: Creation of dataset :
Click on View in Menu bar -> Click On report data (The last of item View)
You will get a new tabbed window namely Report Data.In this window we shall get three fields namely DataSource , Dataset etc.
Step 6: Right click on data set - > Add New dataset - > click new datasource then a new wizard will be open.In this new wizard choose Shared Data Source which you have created earliar.Also choose query type either Text Query Or Stored Procedure.Here we are going to use stored procedure.
Choose name of your procedure from dropdown list.
After this you will get all the field of your table which is used in procedure.
Step 7: Now again come back to your reports design view.
Step 8: Drag & Drop table in which data will be rendered.
Step 9:Provide Header & Footer of Report
Step 10: Right Click on table's cell -->> Choose Expression -
->A new wizard will be open --> Choose Dataset -->> Choose fiels value-->> Click OK
Step 11 : Repeat this step untill your is not completed.
Step 12: Click on preview to view your report.
Step 13 : Provide parameter of the stored procedure.
Step 14: You will get your report also you can download it in any desired format.
Step 2: Click File ->New - > Project
Then you will get wizard having two columns :
a) Project Types & b) Visual studio Installed Templates
From project types choose Business Intelligence Projects from left side and choose Report Server Project Wizard.
Step 3: From Solution Explorer Right Click On Shared Data Source - >Add Shared Data Source
In this open wizard provide name of Shared Data Source and also provide connection strings.
Step 4: Now a blank panel will be open here you can use your own custom controls like table for rendering of data.
before attaching any control first we should create dataset.
Step 5: Creation of dataset :
Click on View in Menu bar -> Click On report data (The last of item View)
You will get a new tabbed window namely Report Data.In this window we shall get three fields namely DataSource , Dataset etc.
Step 6: Right click on data set - > Add New dataset - > click new datasource then a new wizard will be open.In this new wizard choose Shared Data Source which you have created earliar.Also choose query type either Text Query Or Stored Procedure.Here we are going to use stored procedure.
Choose name of your procedure from dropdown list.
After this you will get all the field of your table which is used in procedure.
Step 7: Now again come back to your reports design view.
Step 8: Drag & Drop table in which data will be rendered.
Step 9:Provide Header & Footer of Report
Step 10: Right Click on table's cell -->> Choose Expression -
->A new wizard will be open --> Choose Dataset -->> Choose fiels value-->> Click OK
Step 11 : Repeat this step untill your is not completed.
Step 12: Click on preview to view your report.
Step 13 : Provide parameter of the stored procedure.
Step 14: You will get your report also you can download it in any desired format.
For more upates stay connected.
No comments:
Post a Comment