This course is intended for end-users and IT staff who will produce reports for their organization, department, or group.
In this course, you will learn how to use SQL Server Reporting Services. Explore its basic architecture and gain a basic understanding of the components of SSRS. You’ll then explore tabular and list reports that employ datasets and data regions. As you progress, you’ll learn to add custom expressions, custom functions and format your reports using Visual Studio Data Tools. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You’ll then understand how Reporting Services parameters work and create parameters in ad-hoc SQL. Next, you’ll be building Matrix reports and charts then explore the use of Reporting Services gauges. The Deployment of Reporting Services projects follows using a variety of formats and client-side printing. You’ll gain knowledge of SSRS Security in managing user roles and accounts. You’ll also discover how to view reports using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you’ll learn how to empower your users to create ad-hoc reports using Report Builder.
Upon successful completion of this course, the student will be able to:
- Create tabular and list reports
- Build expressions and how they are used within SSRS
- Use the global, user, field, report and parameter collections
- Create groups using the grouping pane for Row Group and Column Groups
- Use parameters with queries and stored procedures to add flexibility to reports
- Create Matrix reports and see the new features of Matrix reports
- Deploy reports and use the report manager
- Use SSRS Security, SSL and Data Source Security
- Use Reporting Services APIs and Report Viewer Controls
- Create a Web Service, a Web Service Subscription and Custom Assemblies
This course assumes no prior knowledge of SQL Server Reporting Services. This course does assume prior knowledge of querying data. Knowledge of SQL Server, the use of SQL Server Management Studio for development, and Visual Studio Development Tools (VSDT) is helpful.