SQL Server Reporting Services
(SSRS)
SQL SERVER Reporting Services(SSRS)
Installation of SQL Server & Data Tools
Link to SQL SEVER 2017: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server
Creating a SSRS Project
Use the caption option to see the video with subtitles in Spanish or Portuguese.
In this lesson, we’ll create our first Report project using the Visual Studio SSDT Stand Alone version.
CREATING a REPORT
Open Visual Studio Data Tools as ADMINISTRATOR
File à New à Project
Select à Reporting Services
Name the project SalesReport
Do not use the wizard
Creating your First Report
Right Click Report Folder and select ->Add ->New Item
Select Report and name the file SalesReport
Connecting to the DATA SOURCE
First you need to add a Data Source to your project.
Right Click Data Source located on the left of your window
Select ->Add a Data Source
Adding a Dataset
Next Add a Datasets to your project.
Right click the dataset folder
Located on the left of the window under Data Source
select -> add datasets
Connect to the Data Source and use the Query Wizard to select the tables and attributes that you are going to use in your report.
Preview your report
Select FactInternetSales and DimCustomer
Next select the columns
From FactInternetSales à TotalProductCost and SalesAmount
Next in the DimCustomer we are looking at demographics
Select Gender and MaritalStatus
Click ok.
The wizard writes the query for you.
Next, we’ll create a tabular report
On the left side click on Toolbox if the Toolbox is not visible go to
View tab and select Toolbox
Drag and drop a Table from the Toolbox
Grab from the Datasets gender, MaritalStatus, Sales Amount Total Product and drop into the design window
Click on preview to see the data
Conclusion
Thank you for participating to this Basic reporting using SSRS, Visual Studio 2017 SSDT Stand Alone version
If you want to learn more I would suggest to read the following books.
By Prof. Gonzalez Adjunct Professor at New York City College of Technology
Lecturus is a platform that offers training to individuals interested in developing or enhancing their computer skills, as well as a career change or advancement.
Get In Touch
147 Prince St, Brooklyn, NY 11201
- Email: lecturus@outlook.com
- Phone: 929-280-7710
- Hours: Mon-Fri 9 AM - 5 PM
Lecturus is a platform that offers training to individuals interested in developing or enhancing their computer skills, as well as a career change or advancement.
Company
Get In Touch
147 Prince St, Brooklyn, NY 11201
- Email: lecturus@outlook.com
- Phone: 929-280-7710
- Hours: Mon-Fri 9 AM - 5 PM