Learn how to use SSRS, SQL Server Reporting Services, the Report Designer or the Report Builder, Report Manager, Report Layout, Formatting, Data Access, Server Administration and Mobile Reports.
Versions SQL Server 2012 to SQL Server 2017 covered. Report Designer or Report Builder covered.
SSRS Report Development and Delivery
Report developers, Power Users, Excel Users or Complete Beginners.
T-SQL mastery is not required for this course, we provide the T-SQL statements, they do not get in the way of learning the SSRS features.
£350.00 per person Per Day excl VAT
SQL Server Reporting Services Training Course – SSRS Training Course Agenda
- SSRS Overview
- Report Server
- Native Mode
- Report Designer or Report Builder
Report Designer & Report Manager
- Data Sources
- Data Sets
- Report Layout
- Build & Deployment
- Projects & Report Wizard
- First Report using Report Designer
- Connecting to Data
- Table, Matrix and Lists plus the Toolbox
- Formatting of Dates, Currency, Numbers
- Interactive Sorting
- Grand Totals, Subtotals and Running Totals
- Built-in Fields & Parameters
- Cascading Parameters
- Mobile Reports
- Drilldown & Drillthrough
- Linked Reports
- Action Reports
- Stored Procedures or Queries?
- Adding Images
- Data Bars
- Document Maps
- UK Maps
- What is a Report File?
- Configuration Manager
- ReportServer Databases
- Stored Credentials
- Role Assignments