Talk to a Training Advisor
Availability (sort by: location | date)
Request availability by clicking a date. Central London
City
|
 |
About this class For organisations to remain competitive, vital information must be delivered seamlessly. SQL Server Reporting Services augments the ability of SQL Server and other database management systems to meet these demanding requirements. In this course, you acquire the knowledge and skills to take full advantage of the power of SQL Server Reporting Services. Who will the lesson benefit? This course is valuable for those designing, creating or delivering reports from a database. Previous exposure to any database system or spreadsheet data is assumed. What delegates will learn - Leverage SQL Server Reporting Services to produce sophisticated reports
- Author robust reports that extract business intelligence out of your data
- Extract relevant report data using parameters and filters
- Render interactive reports with drill-down and drill-through features
- Deploy reports to a Report Server for centralised access and administration
- Secure reports in the Reporting Services environment
- Embed reports in WinForm and Web Form applications
Contents of this class SQL Server Reporting Services (RS) Architecture - Report types and formats
- RS Web Service
- Report Server
- Report Builder
- Model Designer
- Data sources: SQL Server, Oracle, OLE DB
- Single and Web farm deployment
Authoring Reports Creating basic reports - Tabular
- List
- Matrix
- Chart
- Constructing data sources and Datasets
- Inserting a data region, fields and images
Leveraging expressions - Calculating fields
- Built-in collections
- Integrating expressions in properties
- Applying conditional formatting
Grouping and sorting data - Grouping to multiple levels
- Employing aggregate functions
- Sorting the results
Implementing Parameters and Filters Building parameters into reports - Returning subsets of data with query parameters
- Mapping report parameters to query parameters
- Building cascading report parameters
- Changing chart titles programmatically
- Designing reports for the user's national language
- Passing parameters to stored procedures
- Exploiting multivalued parameters
Restricting report data with filters - Enhancing performance with filters
- Filters vs. query parameters
Leveraging Advanced Reporting Features Combining data regions in one report - Utilising sequential and nested regions
- Producing master/detail reports
- Linking subreports
Presenting data with appropriate detail - Revealing report detail with drill down
- Displaying related data with drill through
- Navigating with document maps
Reporting on non-relational data sources - Building reports on Analysis Services cubes
- Returning cube data and generating MDX using the MDX Builder
- Creating reports on XML data sources
Deploying and Delivering Reports Deploying reports to the server - Preparing reports for publishing
- Configuring project properties
- Units of deployment: Individual reports, projects, solutions, data sources
- Checking results with Report Manager
- Reviewing results with SQL Server
Selecting delivery options - On-demand or by subscription
- Improving performance with cached instances and snapshots
- Configuring snapshot history
Sending subscription reports - Making reports available via e-mail and fileshare
- Delivering reports flexibly through data-driven subscriptions
Securing Reporting Services Securing the RS environment - Mapping out a security plan
- Assigning users to roles
- Setting permissions on report items
- Granting and revoking system-level permissions
Empowering users with ad-hoc reporting - Architecting report models with Model Designer
- Defining data source views
- Creating and retiring models
- Simplifying report models through denormalisation
Creating reports with Report Builder - Deploying Report Builder to users
- Dragging and dropping entities onto charts and tabular reports
- Navigating data with infinite drill through
Programming Reporting Services - Controlling reports using URL access
- Exploiting RS Web services
- Writing a Windows application with Report Viewer controls
- Embedding reports in applications
|
