In this article we will show you, How to create Table Report using report Wizard in SQL Server Reporting Services.
Creating Report using Report Wizard in SSRS 2014
When we right-click on Reports folder it provides various options to design reports.
- Add New Report: Open up the Report wizard to design report.
- Add: Gives us the choice to choose whether we want to design report using Report Wizard or an empty report.
- Import Reports: We can import reports from the file system.
Here we are selecting the first option Add New Report. Once you click on this option, it will open the Report wizard as we shown in below screenshot. First page is a Welcome screen, If you don’t want to see this page again, Please tick mark the Don’t show this page again option.
Select the Data Source
This page is used to configure the Data Source. Here we have two options:
- Shared data Source: If you already created the Shared data Source, Please select the data source name from the drop down list.
- New data Source: If you haven’t already created the data Source, Please select this option and create New data source.
If you select the New data Source then following properties will come into play. Please refer Shared Data Source in SSRS article to understand the properties in detail.
Click on the Edit button to configure the connection string
This page is used to write the SQL Query to extract the data from the Data Source. If you are not familiar with SQL Queries then click on the Query Builder button. Please refer SSRS Query Designer article to understand the steps involved in designing SQL Queries
In this example we are coping from SQL server Management Studio to Query String empty space
SQL Command we used in the above screenshot is:
ORDER BY FirstName DESC,
Select the Report Type: Please select the Report type you wish to design.
- If you are designing Table report, Please select the Tabular option.
- If you are designing Matrix report, Please select the Matrix option.
Design Table: Properties involved in this page are:
- Available Fields: List of columns we got it from the SQL Query we designed before
- Page: If you place anything, it will start new page for every new value
- Grouping: If you want to perform any grouping operations then place that columns in this place.
- Details: Columns added to this tab will be shown as output columns in the Table report.
- Remove: This button will remove column names from Page, Grouping and Details
Because it is very basic report, Please don’t bother about grouping just understand the concept. You can visit other articles to understand these things.
Choose the Table Style: You can select your own style as per your requirements.
Completing the Wizard: Please provide valid name for the report and click on the finish button. Here, We assigned SSRS Report using Report Wizard name as report name
If you observe the above screenshot, You can see the SQL Query, Report Type, Data Source and layout Type details.
Click Finish button to finish creating SSRS report using report wizard.
Click on the Preview button to see the report preview
Thank You for Visiting Our Blog