Create SSRS Report
Please go through below steps :
1. In Visual Studio File -> New Project to create new project.
5. Select Edit Button to configure details, related to our database like Server name, Log on to the server and Connect to database. After that we can verify it with ‘Test Connection‘ to check whether connection is done successfully or not.
You can find used query below:
SELECT FirstName + ‘ ‘ + MiddleName + ‘ ‘ + LastName as Name,AddressLine1 as Address,City,Name AS State,PostalCode
INNER JOIN Person.BusinessEntityAddress on Person.Person.BusinessEntityID = Person.BusinessEntityAddress.BusinessEntityID
INNER JOIN Person.Address on Person.BusinessEntityAddress.AddressID = Person.Address.AddressID
INNER JOIN Person.StateProvince ON Person.Address.StateProvinceID=Person.StateProvince.StateProvinceID
WHERE MiddleName is not null
AND City = ‘Seattle’
8. In next step (Design the Table) we can select Available fields and Display Fields in which area (like Page, Group, and Details), we want fields to show.
We are going to show all fields in details section.
11. Click on Finish button. First SSRS Report is completed.
You can see the report design screen as below. Also we can change Report Design or Data Source details here.We can Preview Report by click on button Preview.
Congratulations!Our First SSRS report is completed.