SQL Server Reporting Services Playbook
Looking to generate and share reports with your organization? In this course you'll get up and running with SQL Server Reporting Services quickly, or just refresh yourself on specific techniques when creating reports.
What you'll learn
SQL Server Reporting Services is a fantastic tool for generating and sharing reports across your organization. This course, SQL Server Reporting Services Playbook, is designed for two types of people. The first is the busy IT Pro, who needs to come up to speed quickly with SSRS. The second is for people who have developed SSRS reports before, and just need a reminder how to do specific tasks. First, you'll learn about creating Line Item reports, both manually and with the wizard. Next, you'll explore creating matrix style reports as well as reports featuring charts and graphs. Finally, you'll learn how to deploy reports to the Report Portal. By the end this course, you'll know the basics so you can start creating reports with SQL Server Reporting Services right away.
Table of contents
- Introducing the Line Item Report 1m
- Using the Wizard 12m
- Working with the Generated Report 3m
- Introducing Manual Report Generation 1m
- Beginning Manual Report Generation 1m
- Manually Adding a Data Source 1m
- Manually Adding a Dataset 1m
- Manually Adding a Table to the Report 1m
- Manually Adding Grouping 1m
- Manually Adding Totals 1m
- Manually Sorting the Detail Data 1m
- Seeing the Results of Your Manual Report 2m
- Introducing Formatting a Report 2m
- Creating a New Report from an Existing One 2m
- Formatting Numeric Values 5m
- Formatting the Printed Page 3m
- Expanding the Design Area 1m
- Resizing Columns in the Table 2m
- Creating a Group Header 2m
- Formatting Text 2m
- Repeating Column Headers on Every Page 3m
- Creating Page Headers 2m
- Creating Page Footers 8m
- Formatting Tips 2m
- Introduction to Parameters 4m
- The Buying Group Parameter - Adding a Parameter with Drop Down Values 8m
- The Year Parameter - A Second Parameter, This Time with Default Values 4m
- The Minimum Total Excluding Tax Parameter - Allowing the User to Enter Values for a Parameter 3m
- Arranging Parameters, Using Default Parameters 3m
About the author
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years' experience in the IT industry, working in a variety of fields including manufacturing, insurance, teleco... more