Sep 8, 2011

SSRS Tutorial

Implementing an SSRS Solution
Implement report data sources and datasets
Query types
 Dynamic data sources
Filter location (dataset vs. query)
Implement a report layout.
Apply conditional formatting
Page configuration
 Headers and footers
Extend an SSRS solution by using code.
Custom .NET assembly
Private code
Create an SSRS report by using an SSAS data source.
MDX in an SSRS report
DMX in an SSRS report
Implement report parameters.
Data bound parameters
Multi-value parameters
Implement interactivity in a report.

Drilldown
 drillthrough
Interactive sorting
Implement report items.
Matrix
Table
Chart
Image
 List
Grouping
Embed SSRS reports in custom applications.
Use the Windows Forms Report Viewer
 Use the Web Forms Report Viewer
 Use the SSRS Web service
Configuring, Deploying, and Maintaining SSRS
Configure report execution and delivery.
Subscriptions
Report caching
Schedules
Snapshot history
Install and configure SSRS instances.
Deploy an SSRS Web farm
Configure authentication and authorization for a reporting solution.

Configure server-level and item-level role-based security
 Configure Windows authentication and custom authentication
Deploy an SSRS solution.
RS.exe scripts
 Report Builder
BIDS
Configure SSRS availability.
Key management
Migrate SSRS databases


No comments:

Post a Comment