Course Content

1. SQL Server Reporting Services1 SQL Server Reporting Services 

• SQL Server Reporting Services (SSRS) Architecture
• Introduction to SQL Server Reporting Services
• Authoring Reports
• Creating basic reports
• Leveraging expressions
• Grouping and sorting data

2. Implementing Parameters and Filters 

• Building parameters into reports
• Restricting report data with filters
• Cascading Parameter
• Report Parameter Vs Query Parameter
• Restricting report data with filters
• Different Data Source in Single Report

3. Leveraging Advanced Reporting Features 

• Combining data regions in one report
• Presenting data with appropriate detail

4. Deploying and Delivering Reports 

• Deploying reports to the server

5. Securing Reporting Services 

• Securing the RS environment
• Creating reports with Report Builder
• Code function and expression knowledge
• Drilldown and Drill through Reports