Procedure to Create a New SSRS Report

The following is the procedure to create a new SSRS Report.

Step 1:

This is the first screen of the project and we click the "Next" button. Select Report Server Project, specify the project name and the finally click the "OK" button.

SSRS-Report-1.jpg
Step 2:

This screen is a Report Wizard. We need to click the "Next" button.

SSRS-Report-2.jpg
Step 3:

SSRS-Report-3.jpg

Change the Name and click the "Edit" button. The Connection properties screen will be displayed.
 
Step 4:

SSRS-Report-4.jpg

First of all choose your server name. Select your database from the Combo Box and then click the "Test Connection" button. (We will see a successful result.)

SSRS-Report-5.jpg

Finally click the "OK" button.
 
Step 5:

Click the Query "Builder Button".

SSRS-Report-6.jpg

Step 6:

SSRS-Report-7.jpg

Select one or more tables from your database and click the "Add" button. The next page is the query builder page. You can write your own query and display the results.
 
Step 7:

We choose the Columns from the Products table and we can see that. The next page I'm going to execute my query.

SSRS-Report-8.jpg
 
Step 8:

SSRS-Report-9.jpg
 
Step 9:

Then click the "Next" button.

SSRS-Report-10.jpg
Step 10:

This screen will open the option to select how the result should display. I choose tabular type. Click on the "Next" button.

SSRS-Report-11.jpg

Step 11:

If you will see the option here to group the data and show it. It depends on your reports structure.

SSRS-Report-12.jpg

Step 12:

I can drag and drop data from Available fields to Details.

SSRS-Report-13.jpg
Then on click the "Next" button.

Step 13:

SSRS-Report-14.jpg

In this page we see 6 defaults templates. I choose the Slate template and all of the users see this it. Then click  the "Next" button.
 
Step 14:

This is the last page. We will see all the configuration settings here such as Data source information, Report type and style, and your query ext…

SSRS-Report-15.jpg
First of all write your Report name and click "Preview Report" (optional). Then click on the "Finish" button.
 
Step 15:

Here is the results.

SSRS-Report-16.jpg


Similar Articles