Learn Hands-On how to create a basic report using SQL Server Reporting Services

This course introduces Microsoft's SQL Server Reporting Services 2014 (SSRS) utility but is also applicable to Microsoft SQLserver Reporting Services 2016 as well as SQL Server 2008 R2 release and later versions. This course is for anyone
who wants to develop reports and has no prior experience with SQL Server Reporting Services. I will walk you through how to use the development tools effectively to create, enhance and present reports.

The course starts off by setting up the environment which includes the installation of Microsoft SQL Server,SQL server Data Tools, Microsoft Visual Studio and also the download and installation of AdventureWorks 2014 sample database. We
Will then explore the SQL Server Reporting Services Configuration which is configuration tool used to configure SSRS.
Whether you’re new to reporting services, or experienced with earlier versions, we’ll show you how to design and build reports and Leverage SSRS to extract business intelligence from your data. We will create dataset from our data source and use T-SQL to create aliases ,aggregate functions,table-joins,grouping data with the having clause.

Topics include:
Configuration of SQL Server Reporting Services
Granting user access to the Reporting Services Server
Creating a Report Server
Defining a data source
Defining a Dataset
Customizing report parameters
Formatting Reports
Grouping Data in Reports
Adding Totals to Reports
Publishing and Deploying Reports through Report Server