Enable Technology

Database 

Microsoft SQL Server Reporting Services SSRS 2016




Course Overview


This three day intensive course will give delegates a comprehensive understanding of how to design and publish parametrised reports, manage permissions, schedule automated reporting and configure report caching. The course also demonstrates how to build reports designed for tablets and mobile devices.

Duration: 3 day course



Course Content


Topics include

Introduction to Reporting Services
Introduction to reporting services
Reporting services components
Reporting services tools

Reporting Services Data Sources
Configuring data access with report builder
Configuring data access with report designer
Using Datasets

Creating Paginated Reports
Create a report using report builder or report designer.
Creating a report with the report wizard
Publish a report to reporting services

Working with Reporting Services Data
Data filters
Report parameters
Implementing report filters and parameters

Visualizsng Data with Report Services
Formatting data
Images and charts
Databars, sparklines, indicators, gauges, and maps
Use databars, sparklines, and indicators in reports

Summarising Report Data
Sorting and grouping
Report sub-reports
Drilldown and drill through

Sharing Reporting Services Reports
Schedules
Report caching, snapshots, and comments
Report subscription and delivery

Administering Reporting Services
Secure access to reports by using authentication, permissions, and SSL encryption.
Use report services configuration manager to reconfigure SSRS servers.
Monitor and optimize the performance of SSRS on a given set of server hardware

Extending and Integrating Reporting Services
Work with expressions and embedded code.
Extend reporting services functionality with external assemblies.
Integrate reporting services with other software

Designing Reports for Tablets and Mobile Devices
Overview of mobile reports
Preparing data for mobile reports
Mobile report publisher
Drillthrough in mobile reports
Add a drillthrough to a custom URL






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;