SSRS Demo Using Stored Procedure with Parameters

1. Type the Name as per the your requirement . Try to have a strong name . 
2. Click on edit Button and enter the connection string Means which server you want to connect 
3. Click on OK button to continue .

Connection Properties:

1. Server Name : Select the server name from where you are generating report . Enter the server name in that drop down box .
2. Log on to the Server : Select in which mode authentication is required . if you click on user windows Authentication then user name ,Password . if you click on use sql server authentication then we need to enter both user name and password .
3. Click on Test Connection to test wither connection was established are not
4. Once all the information is filled OK Button will be enabled.

Shared DataSets:

1. Right Click on the Shared DataSets and click on Add New Dataset .

Shared Dataset Properties:

1. Name : Enter the dataset Name.
2. Select the Data Source. If we have multiple data source select the required one .
3. Click on the Stored Procedure . and select the report required stored procedure .
4. Select the Stored procedure name .
5. Click OK button to continue .

Adding Report:

1. Click on Add button to add a new report .

1. Click on report .
2. Type the Report name as per your requirement .
3. Click ok button to save and continue .

1. Drag and drop the table over the design portion .

1. Arrange the columns as per your requirement .
2. Once the required columns are bind .. it looks like below .

Preview of the report:

Conclusion: