This course is an instructor-led classroom course aimed at analysts and IT professionals who are familiar with building basic reports with ReportBuilder 3.0 and SQL Server Reporting Services (SSRS) - all versions from SQL Server 2008R2 to SQL Server 2017.
The course builds on the foundation skills for report writing with Microsoft ReportBuilder and SSRS. Delegates will extend their knowledge to: create parameterised reports, build complex expressions using scalar and aggregate functions, implement list regions, drill down, drill-through and hyperlinks, add subreports, enhance reports by implementing sparklines, data bars and indicators.
Delegates may wish to build on the skills acquired during this course by attending the "Writing Reports With Microsoft Report Builder SSRS Level 2" course, which covers more advanced topics such as creating parameter reports, list reports, adding images and subreports, adding sparklines, data bars and indicators.
Delegates attending this course should have a knowledge of ReportBuilder to the level covered by the "Writing Reports With Microsoft Report Builder SSRS Level 1" course .
Create Report Parameters
Modify Report Parameters
Provide Default Parameter Values
Provide Available Values for Parameters
Introducing the List Data Region
Create Reports Using List Data Regions
Modify Reports Which Use List Data Regions
Top N Reports
Add Images to Reports
Retrieve Images from a Database
Introducing SSRS (SQL Server Reporting Services) Report Server