Attendees will learn how to use the Reporting Services development tools to create reports, and additionally how to use the Reporting Services management and administrative tools.
This course is intended for IT professionals and developers who need to implement reporting solutions by using SQL Server 2012 Reporting Services.
NOTE: This course is also available for SQL Server 2008, please contact us for more information.
Delegates should have experience using:
- Microsoft Access or other third-party reporting products (e.g., Crystal Reports)
- Windows services (starting and stopping)
- SQL Server query language (SELECT, UPDATE, INSERT, and DELETE)
- This can be gained by attending our Microsoft SQL Server Introduction to Querying class
- SQL Server accounts (users and permissions)
2 days. Hands on.
Concise coverage of the subject matter is augmented with plenty of hands on exercises to facilitate the learning process and to enable students to quickly gain confidence in using Reporting Services.
Key course objectives include:
- Introduce the role that Reporting Services plays in an organization’s reporting life cycle, the key features offered by Reporting Services, and the components that make up the Reporting Services architecture.
- Introduce the fundamentals of report authoring, including configuring data sources and data sets, creating tabular reports, summarizing data, and applying basic formatting.
- Introduce navigational controls and some additional types of data regions, and discuss how to use them to enhance a basic report.
- Explore data sets to a greater depth, including the use of alternative data sources and interacting with a data set through the use of parameters. Delegates learn how to dynamically modify the data set underlying a data region by allowing parameters to be sent to the underlying query. They also learn to use best practices to implement static and dynamic parameter lists when interacting with queries and stored procedures.
- Explain the various options for publishing reports to the report server and executing them.
- Discuss how to administer the Reporting Services server, how to monitor and optimize the performance of the report server, how to maintain the Reporting Services databases, and how to keep the system secure.
- Explain how to query Reporting Services information programmatically and how to automate report management tasks. Delegates also learn how to render reports without relying on Report Manager, and how to extend the feature set of a report server by creating custom code.
Introduction to Microsoft SQL Server Reporting Services
Describe the features of SQL Server Reporting Services
Install Reporting Services
Describe the Reporting Services tools
Authoring Basic Reports
Creating a Basic Table Report
Formatting Report Pages
Enhancing Basic Reports
Create reports with interactive navigation
Display data in various formats
Manipulating Data Sets
Defining Report Data
Using Parameters and Filters
Using Parameter Lists
Publishing and Executing Reports
Creating Cached Instances
Creating Snapshots and Report History
Administering Reporting Services
Performance and Reliability Monitoring
Administering Report Server Databases
Programming Reporting Services
Query server information by using a Web service
Automate report management
Create custom code