Course 6: SQL Server Reporting Services (SSRS) Part I
6 STUDENTS ENROLLED
After completing this course, the student will be able to install SQL Server 2016, install Microsoft Visual Studio and create from scratch reports from simple to complex reports that aid in upper management in making important business decisions. The course will cover the following:
- Creating, formatting, designing, and submitting reports
- Learn how to navigate through Microsoft Visual Studio
- Learn how to save .rdl files, create templates, render reports in various format
- Avoid redundant input of data
- Become well versed in the ability to help the organization in moving forward with summary visual data
Course Curriculum
1. SSRS - SQL Scripts | |||
SSRS SQL Scripts | 00:00:00 | ||
2. What is SQL Server Reporting Services | |||
What is SQL Server Reporting Services | 00:00:00 | ||
3. Download Site for SQL 2016 Server | |||
Download Site for SQL 2016 Server | 00:00:00 | ||
4. Data Tools | |||
Data Tools | 00:00:00 | ||
5. Sample Database | |||
Sample Database | 00:00:00 | ||
6. First Report | |||
First Report | 00:00:00 | ||
7. Formatting Report | |||
Formatting Report | 00:00:00 | ||
8. Freeze The Header | |||
Freeze The Header | 00:00:00 | ||
9. Table Item | |||
Table Item | 00:00:00 | ||
10. Header and Footer | |||
Header and Footer | 00:00:00 | ||
11. Grouping and Drill Down | |||
Grouping and Drill Down | 00:00:00 | ||
12. Grouping Totals and Subtotals | |||
Grouping Totals and Subtotals | 00:00:00 | ||
13. Grand Total | |||
Grand Total | 00:00:00 | ||
14. Multiple Drill Down Part 1 | |||
Multiple Drill Down Part 1 | 00:00:00 | ||
15. Multiple Drill Down Part 2 | |||
Multiple Drill Down Part 2 | 00:00:00 | ||
16. Images | |||
Images | 00:00:00 | ||
17. Matrix | |||
Matrix | 00:00:00 | ||
18. Charts | |||
Charts | 00:00:00 | ||
19. Sub Report | |||
Sub Report | 00:00:00 | ||
20. Subreport Embedding | |||
Subreport Embedding | 00:00:00 | ||
21. Indicators | |||
Indicators | 00:00:00 | ||
22. List Report | |||
List Report | 00:00:00 | ||
23. Parameters | |||
Parameters | 00:00:00 | ||
24. Create Parameter | |||
Create Parameter | 00:00:00 | ||
25. Cascading Parameters Part 1 | |||
Cascading parameters Part 1 | 00:00:00 | ||
26. Cascading Parameters Part 2 | |||
Cascading Parameters Part 2 | 00:00:00 | ||
27. Conditional Formatting | |||
Conditional Formatting | 00:00:00 | ||
28. Templates Part 1 | |||
Templates Part 1 | 00:00:00 | ||
29. Templates Part 2 | |||
Templates Part 2 | 00:00:00 |