SQL Server Reporting Services

• Architecture and tools
• Managing web farm deployment

• Report Building with Report Builder and Visual Studio
• Accessing the power of SQL Server Mobile Report Publisher

Designing fundamental reports

• Connecting to relational and multidimensional sources
• Generating a Tablix reporting structure

Composing expressions

• Computing custom fields
• Linking expressions to properties

Arranging and sorting data

• Multiple-level grouping and categorizing the results
• Applying aggregate functions

Producing various outputs from a Tablix

• Creating parallel dynamic group report formats
• Combining dynamic and static columns

• Yielding subsets of data with query parameters
• Constructing cascading report parameters
• Transmitting parameters to stored procedures

Applying filters to report data

• Augmenting performance with filters
• Determining filters vs. query parameters

• Applying sequential and nested regions
• Creating master/detail reports and linking subreports

Showing robust data with relevant detail

• Drilling through report detail and drilling down
• Navigating reports with document maps

• Publishing reports and configuring project properties
• Verifying results with Report Manager

Identifying delivery options

• Enhancing performance with cached instances
• Configuring snapshot history

Dispatching subscription reports

• Publishing reports via e-mail and file share
• Seamlessly delivering reports by data-driven subscriptions

• Leveraging existing Windows authentication
• Establishing permission levels on report items

Ensuring the RS system

• Instituting varying levels of administrative roles
• Granting and revoking system-level permissions

• Exploiting cubes as intuitive data sources for nontechnical and power users
• Generating parameterized reports with MDX Builder Designing reports for data visualization
• Improving data visualization with sparklines, data bars, maps and indicators
• Implementing Key Performance Indicators (KPIs)

Delivering reports to users

• Accessing and controlling reports using URLs
• Embedding reports in applications with the Report Viewer