Building nice looking professional quality reports doesn’t have to be difficult or even time consuming. If you have the right tools and some basic knowledge, report authoring can be one of the most rewarding activities. SQL Server Reporting Services is definitely the right tool and this course teach you the basic knowledge.
In this training you will learn how to create pixel-perfect reports that retrieve information from SQL Server. You will work with the report designer to combine tables, textboxes, charts, gauges, maps, and images to create list reports, drill-down reports, map bubble reports, dashboard reports, invoice reports, and many more.
In this course, veteran consultant, Joey Blue, leads you through lessons where you will work with a fictitious music delivery company and you will be faced with real world scenarios that will force you to create 10 different reports in an iterative manner. All of this report authoring is done on your laptop or desktop pc. There are videos that show you step-by-step how to setup your computer to work through the examples as you watch the videos.
The only prerequisite for this course is an Internet Connection and a PC. You don’t even need to know SQL. Everything else will be taught in the course through the video lessons.
Report Authoring is a great skill for today’s economy.
Just click the “Take This Course” button above, fill out the information, and we’ll see you on the other side.
This is an overview of how to use this training. You will also find the supplementary materials like, learning outline, slideshow, customer invoice sample, and logos that are used in the course.
You will use SQL Server for this training. This video shows you how to install SQL Server.
SQL Server Express Advanced is a free download: http://www.microsoft.com/en-us/download/details.aspx?id=29062
The Chinook Database is what you will use when you create reports. This video shows you how to install the Chinook Database
Here is the link to the Chinook Database: http://chinookdatabase.codeplex.com/
The Chinook Database is your training database. This is meant as an overview to help you get familiar with your training database.
Here is a link to the Chinook database: http://chinookdatabase.codeplex.com/
This foundation video is a whiteboard drawing video describing the different components that make up SQL Server Reporting Services. This is the big picture even though your focus for this training will be on Report Authoring.
SQL Server Reporting Services is made of many different tools. This will help you understand what tool you will focus on for this training.
During your training, you can always ask me questions in the lesson comments or through email. But, you should also be aware of all of the other great resources out there. This video shows you how to find answers when needed.
SQL Server Data Tools stores your reports in Projects and Solutions. This teaches you how to get started with the report authoring tool (SSDT).
This lesson helps you understand the how Reports, Projects, and Solutions all relate to one another.
You will need to close and open your report project as you go through your training. This lesson teaches you how to open the project back up once you have closed everything down.
· Create a New Report
· Report Wizard
· Data Source
· Data Set
· Tabular Report
· Execute Report
· Modify Table Column Sizes
· Opening an Existing Report
· Modifying an Existing Report
· Sorting and Ordering
· Using a shared data source
· Linking tables
· Assigning columns for page breaks and grouping
· Enabling subtotals and drilldown
· Column Resizing
· Date Formatting
· Removing Subtotals
· Looking at the Grouping in a Table
· Editing an Existing Report
· Matrix Report
· Column Grouping
· Row Grouping
· Interactive Report
· Create Parameters
· Create a dataset to select a city
· Processing Order
· DataSource, DataSet, .RDL file, XML
· Parameters and Order that the dataset gets processed.
· Create a report without the Wizard
· Using the Toolbox
· Using a Textbox
· Using a Table
· Manually Creating a Drilldown
· Adding Columns
· Formatting Groups
· Properties Window
· Parameter with All Selection
· Displaying Parameters
· Default Parameter
· Displaying a Parameter
· String Concatenation
· Expression Editor
· Merge Cells
· Using the Chart Object
· Formatting Axis
· Copy an Existing Report
· Rename a Report
· Scale Breaks with in a Report
· Second Chart Area
· Secondary Value Axis
· Calculated Field
· Pie Chart
· Data Label Property
· Chart Palette
· 3D Effect
· Map Chart
· Bubble Map
· DateAdd Function
· Between Function
· Dashboard Report
· Using Gauges
· Date Parameter
· Connecting Multiple Tables
· Creating Extra Records in Joins
· Border Formatting
· Textbox Item Formatting
· Expression Editor
· First Function
· Total in a Table
· Textbox Formatting
· String Concatenation
· Report Layout Techniques
· Padding Property for Indenting
· Formatting Multiple Objects
· Adjusting Heights
· Inserting Logo
· Merging Cells for Table Layout
· Column Resizing
· Advanced Layout with Tables
· Textbox Alignment
· Bolding within Textbox
· Adjusting Multiple Textboxes
· Clipping Image
· CTRL for Smoot Adjustments
· Export to PDF
· Improving Image Export to PDF
· Report Footer
· Execution Time Global Variable
· Deployment Settings
· Report Server
· Report Manager
· Sharing and View Reports with Report Manager
· 10 Reports
· Using Wizard
· Without Wizard
· SQL Server Data Tools
· Drill Down Reports
· Charts, Gauges, Maps, and Dashboards
· Invoice Report
· Database Queries with Query Designer
· Practice, start using the reports in your job
· Take an advanced SSRS Report Authoring course
· Take a SSRS course on SSRS Architecture and Management
· Learn SQL Queries and Stored Procedures
· Learn more about Business Intelligence
Joey has been working with SQL and Relational Databases for over 13 years. He has also been a consultant working with Data Integration, Business Intelligence, Data Warehousing, and Corporate Reporting. He also has a degree in Mathematics and a Master's in Business Administration.