TOIT Training

Log in

Menu
Contact Sales
Roadmap

Advanced SSRS

Last updated: May 6, 2026

Overview

Report Developers must hold unique traits to set themselves and their work apart from others. This class is designed to take you to the next level in your understanding of SQL Server 2016/2017 Reporting Services (SSRS). We use a variety of lab exercises to ensure lecture sessions are backed up by hands on experience. With the hands-on labs, you will learn how to create complex reports that use Analysis Services as a data source and custom code assemblies.

Curriculum

  • 36 Sections
  • 0 Lessons
  • 8 Hours
Expand all sectionsCollapse all sections
  • 01. Class Introduction
    0
    • 02. Report Design Patterns
      0
      • 03. Using SSAS as a Data Source (Designing a Basic Report - Multidimensional)
        0
        • 04. Using SSAS as a Data Source (Designing a Basic Report - Tabular)
          0
          • 05. Using SSAS as a Data Source (Building a Dynamic Report)
            0
            • 06. Using SSAS as a Data Source (Tips and Tricks)
              0
              • 07. .Net Integration (Why Use Custom Code)
                0
                • 08. .Net Integration (Embedded Custom Code)
                  0
                  • 09. .Net Integration (External Assemblies)
                    0
                    • 10. Advanced SSRS Expressions (Advanced Functions)
                      0
                      • 11. Advanced SSRS Expressions (Launch Office Tools From Your Reports)
                        0
                        • 12. Advanced SSRS Expressions (Launching Bing Maps)
                          0
                          • 13. Report Manager (Linked Reports)
                            0
                            • 14. Report Manager (Object Visibility)
                              0
                              • 15. Report Manager (My Reports)
                                0
                                • 16. Report Builder (Train the Trainer)
                                  0
                                  • 17. Report Builder (Using Report Parts)
                                    0
                                    • 18. SSRS Configuration (Setting up your SSRS Server)
                                      0
                                      • 19. Report Utilization (Setting up the Solution)
                                        0
                                        • 20. Report Utilization (Usage Reports)
                                          0
                                          • 21. Security (Assigning Report Server Permissions)'
                                            0
                                            • 22. Security (Creating Custom Security Roles)
                                              0
                                              • 23. Performance Tuning (Report Snapshots)
                                                0
                                                • 24. Performance Tuning (Report Caching)
                                                  0
                                                  • 25. Performance Tuning (SSRS Performance Counters)
                                                    0
                                                    • 26. Planning a Web Farm Architecture
                                                      0
                                                      • 27. Data Driven Subscriptions (Building a Basic Subscription)
                                                        0
                                                        • 28. Data Drive Subscriptions (Using Data Driven Subscriptions)
                                                          0
                                                          • 29. Accessing Your Report Server Remotely
                                                            0
                                                            • 30. Miscellaneous (Creating Report Templates)
                                                              0
                                                              • 31. Miscellaneous (Using Document Maps)
                                                                0
                                                                • 32. Miscellaneous (Reporting On Recursive Data)
                                                                  0
                                                                  • 33. Miscellaneous (Refreshing Report Data From Word, PowerPoint, Etc.)
                                                                    0
                                                                    • 34. Miscellaneous (Using Reports to Start SQL Agent Jobs)
                                                                      0
                                                                      • 35. Power BI Integration (Deploying SSRS Report Visuals to Power BI)
                                                                        0
                                                                        • 36. Power BI Integration (Power BI Report Server)
                                                                          0

                                                                          Instructor

                                                                          User Avatar
                                                                          ToIT
                                                                          2 Students
                                                                          1351 Courses
                                                                          course thumbnail
                                                                          Free
                                                                          Student:
                                                                          0 Students
                                                                          Lesson:
                                                                          0 Lessons
                                                                          Duration: 8 Hours
                                                                          Quiz:
                                                                          0 Quizzes
                                                                          Level: Expert