Intertech’s SQL Server Reporting (SSRS) training courses deliver a solid understanding of the practical application and use of SSRS. Students learn the solution types available in SSRS, the basics of installation, and role and use of the windows service, processors, and extensions. Administration of SSRS is also a section in our courses and includes primers on security, backup and recovery, monitoring, using report manager, and content management activities. All classes are instructor led and can be taken in a classroom setting or live online. See more details below about our class offering.
SSRS training courses cover report layout types and how to design multicolumn reports. Further, the courses cover best practices for data access, use of relational data, and filtering techniques. The core reporting sections of the courses can cover more advanced report design topics such as headers and footers, report templates, composite reports, sub-reports, super-reports, and reporting on recursive relationships.
User reporting is also a covered topic including the use of PowerPivot, Power View, and best practices for report migration, version control and content synchronization. Depending on the SSRS training course, there can be coverage of SSRS extensions thru interfaces, how to create custom data processing extensions, and the integration of SSRS with custom applications including URL access and theReportViewer control.
Depending on the SSRS training course, the courses cover integration with other Microsoft products like SharePoint or SQL Server Analysis Services (SSAS). For SharePoint, SSRS integration and SharePoint configuration, using native and integrated mode web parts, and publishing reports to SharePoint are topics of learning. In SSAS, areas are covered including MDX and cube formatting, drill thru reports, and OLAP techniques such as cube dynamic rows and cube meta data.
For course specific information, please select the outline from the list of courses at the top of this page.