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.
Step 2:
This screen is a Report Wizard. We need to click the "Next" button.
Step 3:
Change the Name and click the "Edit" button. The Connection properties screen will be displayed.
Step 4:
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.)
Finally click the "OK" button.
Step 5:
Click the Query "Builder Button".
Step 6:
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.
Step 8:
Step 9:
Then click the "Next" button.
Step 10:
This screen will open the option to select how the result should display. I choose tabular type. Click on the "Next" button.
Step 11:
If you will see the option here to group the data and show it. It depends on your reports structure.
Step 12:
I can drag and drop data from Available fields to Details.
Then on click the "Next" button.
Step 13:
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…
First of all write your Report name and click "Preview Report" (optional). Then click on the "Finish" button.
Step 15:
Here is the results.