SSRS – SQL Server Reporting Services

Module 1: SSRS Architecture & Setup

• SSRS architecture: Report Server, Report Manager, SSDT
• SSRS vs Power BI: paginated vs interactive reporting
• SSRS installation and configuration
• Report Server configuration manager: service accounts and URLs
• SSDT Report Designer: authoring environment
• Report Builder: self-service reporting tool

Module 2: Data Sources & Datasets

• Shared data sources vs embedded data sources
• SQL Server, Analysis Services, and OLEDB connections
• Dataset definition: query, stored procedure, expression
• Query Designer: visual SQL query building
• Dataset parameters: dynamic dataset queries
• Shared datasets for cross-report reuse

Module 3: Report Layout & Design

• Tablix: the foundation of SSRS data regions
• Table report: row-per-record tabular layout
• Matrix report: cross-tab pivot layout
• List: free-form layout for complex reports
• Headers and footers: page numbers, report info
• Text boxes, images, lines, and rectangles

Module 4: Grouping, Sorting & Aggregates

• Row groups and column groups in Tablix
• Group headers and footers: subtotals and labels
• Sorting: interactive sort on report columns
• Aggregate functions: Sum, Count, Avg, Min, Max, First, Last
• Running totals and cumulative aggregates
• Percentage of total and percentage of group

Module 5: Parameters & Filtering

• Report parameters: single and multi-value
• Cascading parameters: dependent parameter lists
• Default and available values from queries
• Parameter visibility: visible, hidden, internal
• Filters on datasets, data regions, and groups
• Report-level filtering vs dataset-level filtering

Module 6: Charts, Gauges & Maps

• Chart types: bar, column, line, pie, scatter, area
• Chart axes, legends, and data labels
• Sparklines and data bars in Tablix cells
• Gauge: radial and linear performance indicators
• Map report item: geographic data visualisation
• Indicators: KPI status icons in reports

Module 7: Subreports, Drilldown & Drillthrough

• Subreport: embedding one report inside another
• Drilldown: toggle visibility of detail rows
• Drillthrough: linking to detail reports
• Report actions: go to URL, go to report, bookmark
• Document maps: report navigation aids
• Interactive features: sorting, visibility, and linking

Module 8: Deployment, Subscriptions & Security

• Deploying reports to SSRS Report Server
• Report Manager and SSRS web portal
• Standard subscriptions: email and file share delivery
• Data-driven subscriptions: personalised report delivery
• Role-based security: item and system level roles
• Report execution snapshots and caching

Our SSRS instructors are Microsoft-certified BI developers and SQL Server professionals who have built enterprise reporting solutions for finance, operations, and compliance reporting across healthcare, retail, and government organisations. They teach SSRS as both an art and a science — combining technical skills with report design best practices.