Tuesday, April 15, 2014

Working with RDLC Reports

Open visual studio

File->New Project ->Select Windows Application


And click on Ok Button.


Go to Tool Box.

Reporting

Select Report Viewer.



Now, Go to Solution Explorer

Now Add->Add New Item



Select dataset and click on Add.



Now Add->Add New Item






Go to Tool Box, and Select Table


On selecting Table the following Dataset will be displayed.




In Data source (Click on New )

Now Select DataBase.





Click on Next Button.



Click on Next Button.




Click on New Connection.



Give your Sql server Name and type of authentication.

Username and Password if selected SQL Server Authentication.


And Click on Test Connection to test the connection the connection string.




And click on Ok Button.



And select the Radio Button


And Click on Next Button.


And Click on Next Button.



And Select the Stored Procedures




And Click on Finish Button.



And Click On Ok Button.

And the following screen will be displayed in Report.



Write your Header Name

And in Data row select the Table Symbol icon and select the column Names.




 And now , go to ur form,

And select the datasource 



And run the form.

Output:




No comments:

Post a Comment

Thank you for visiting my blog

Kubernetes

Prerequisites We assume anyone who wants to understand Kubernetes should have an understating of how the Docker works, how the Docker images...