SQL Server Reporting Services SSRS
0 likes503 views
The document provides instructions for creating SQL Server Reporting Services reports, including starting a new project in SQL Server Data Tools, creating a shared data source by selecting a SQL server and database, adding a query using the query builder, and generating a report using the data source.
SQL Server Reporting Services SSRS
- 1. Ahmed Al Salih MS.IT A.AlSalih2@gmail.com SQL Server Reporting Services
- 2. Ahmed Al Salih MS.IT A.AlSalih2@gmail.com Run SQL Server Data Tools from Start menu Start New Project
- 3. Ahmed Al Salih MS.IT A.AlSalih2@gmail.com Creat new shared data sources Right click and select Add New Data Source
- 4. Ahmed Al Salih MS.IT A.AlSalih2@gmail.com Give name to your new data source Under the connection seting click Edit and from the new windows choice the sql server and the database you want to work on it
- 5. Ahmed Al Salih MS.IT A.AlSalih2@gmail.com In the Server name as you see I type . To point to the local server in my machine, in the select or enter a database name: I use the AdvantureWorksDW2012 database. And you would test the connection
- 6. Ahmed Al Salih MS.IT A.AlSalih2@gmail.com Click ok to go back to the previce window to see the connection setting Click Ok
- 7. Ahmed Al Salih MS.IT A.AlSalih2@gmail.com Creat Report Right click on the Reports tab and click on Add New Report Click next
- 8. Ahmed Al Salih MS.IT A.AlSalih2@gmail.com Choice your data source that you created on th top and click next Past your query or you can use query builder: