Overview
Syllabus
Start
Introduction
Introduction to Reporting Services
Reporting Services Components
Reporting Services Tools for Report Authoring
Tools for Report Server Admin - Native Mode
Tools for Report Server Admin - SharePoint Integrated Mode
Tools for Report Content Management
Software Requirements
Introduction to Reporting Services Data Sources
Data Sources
Connecting to SQL Server Management Studio
Restoring the WideWorldImporters Database
Importing Queries for the Class into SSMS
Accessing the Web Portal from RSCM
Creating a Shared Data Source in SSRS
Accessing Report Builder from SSRS
Creating a Dataset in Report Builder
Adding Extensions in Visual Studio
Creating a Project in Visual Studio
Creating a Shared Data Source in Visual Basic
Creating a Shared Dataset in Visual Studio
Reporting Services Data Sources Recap
Introduction to Paginated Reports
Creating Paginated Reports with Report Wizard
Modifying Values and Date Formats
Adjusting Columns and Repeating Items
Creating a Paginated Report from Scratch in Visual Studio
Adjusting Column Headings and Widths
Manually Setting Row Grouping
Changing Date and Number Formats
Grouping Rows and More Adjustments to Columns
Adding and Repeating Report Headers Across All Pages
Using the Wizard to Create a Table Report
Publishing Reports
Setting Target URL and Deploying Solution
Paginated Reports Recap
Conclusion
Taught by
Learnit Training