How To Create Ssrs Report In Asp Net

How to create a SSRS report in ASP.NET with an example

April 17 2020 by Admin   

In this article, we will explore how to create an SSRS report in ASP.NET with example and sample code.

---

In this article, we will explore how to create an SSRS report in ASP.NET with example and sample code. In this example, we have bound the customer's details in SSRS report. Refer to the steps for database connection.

Step -1

Open Visual Studio and select SSRS report project Once the project is created, add the data source to which the project is should be referred.

Step -2

From the below image, you can see the list of connection type. Mostly, we use sql server database. After selecting the database, click ok .

Step -3

Select the server name and the system automatically refreshes the database list. Now select the database on which you are working and test the connection using test connection button. If the connection is successfully established, below message is shown.

Step -4

On Successful addition you will be able to see the database name under the shared data sources folder with .rds extension. Now its time to add the report.

Step -5

Right click on the add new report. This will pop up the below screen.

Step -6

Now select the data source for the database you have selected and click next as shown in the below picture and click next.

Step -7

Now the query of the command in the query editor box.

Step -8

You can also use query builder function that will display all the tables of the database.

Since the query is ready for me, I have directly pasted it in the box. Now click on next. This will display the type of report you want to develop.

Step -9

There are two type of reports.

1. Tabular reports: - This report is used to display the data in the table format.

2.Matrix reports: - This report format is used to display the report in the pivot format. Since my report was in tabular format, I have tabular report.

Now Click on next.

Step -10

Now the system will display all the columns you have selected in the query. You can define where you want to use the column. This is shown in the below images .

Once done, click on next

Step -11

This option will provide you the stepped or block report format. For me, I had to use stepped report. Now click on next .

Step -12

Give the report name as shown in the below picture. Click on Finish.

Step -13

If you want to show the report preview then check on the preview report checkbox and then click next or directly click next.

That's done. The report screen will appear on the below screen.

Step -14

On completing the report, please set the report project properties as below the image shown below.

Step -15

To preview the report, click on the preview tab to show the report data.

Tags :
• SSRS
• SQL Server
• C#

Note: All contents are copyright of their authors.

How To Create Ssrs Report In Asp Net

Source: http://aspsolution.net/Code/1/5149/How-to-create-a-SSRS-report-in-ASPNET-with-an-example/

Posted by: greenlyharsecy.blogspot.com

Share this post