Creating Reports with SQL Server 2012 Reporting Services
4.1 (28 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
352 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Creating Reports with SQL Server 2012 Reporting Services to your Wishlist.

Add to Wishlist

Creating Reports with SQL Server 2012 Reporting Services

A concise, fast-paced tutorial that demonstrates how to efficiently create a variety of practical reports with SSRS
4.1 (28 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
352 students enrolled
Last updated 12/2014
English
Price: $85
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Utilize the Report Wizard to quickly get a report started
Format data in tables and matrices
Add interactive sorting and high-impact visualizations such as pie charts, gauges, and bar graphs
Build expressions and implement built-in variables
Create drill-down and drill-through reports
Maximize report flexibility through the use of parameters
Combine report objects to create a dashboard
View Curriculum
Requirements
  • The content is delivered in a concise, conversational style that emphasizes efficiency in development while empowering you to maximize the functionality and impact of your reports created with SQL Server Reporting Services.
Description

Creating Reports with SQL Server 2012 Reporting Services will show you how to develop practical reports that utilize tables and matrices, along with bold objects such as pie charts and gauges that quickly gain the attention of the viewer and deliver your message. With this course, you can acquire the essential skills you need to make an impression on your customers, your audience, or your boss.

About the Author

Dr. Dallas Snider is an Assistant Professor in the Computer Science Department at the University of West Florida (UWF). He received his Ph.D. in Integrated Computing and M.S. in Instrumental Sciences from the University of Arkansas at Little Rock. He received his B.A. in Physics from Hendrix College in Conway, Arkansas. Before joining UWF, he worked as a Data Warehouse Developer for Northrop Grumman Information Systems, and prior to that as a Database Application Developer for Acxiom and Euronet. Dr. Snider's research and teaching interests include data mining, data warehousing, software development, and security.

Who is the target audience?
  • Creating Reports with SQL Server 2012 Reporting Services is designed for those who have a working knowledge of SQL and who need to deliver business intelligence via impressive, interactive reports. You will need a version of SQL Server 2012 that includes the SQL Server Data Tools. This thorough course requires basic experience with SQL Server and reporting.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 39 Lectures Collapse All 39 Lectures 01:41:39
+
The Report Wizard
5 Lectures 16:12

Populating the Select the Data Source screen in the Report Wizard.

Data Sources
03:23

The user is given a choice of pressing the Query Builder button or entering their query in the Query string textbox.

Report Queries
02:19

The report type we choose is heavily dependent on the query and the type of information we wish to convey in the report.

Tabular Report Types and Their Configuration
03:47

Report Wizard's Design the Table screen will save much time and effort while creating new tabular and matrix reports.

Matrix Report Types and Their Configuration
03:28

The Choose the Deployment Location screen of Report Wizard only appears the first time a report is created in a new SSRS project. The deployment settings can be changed by selecting the Project properties in Visual Studio.

Deployment Location and Completing the Wizard
03:15
+
Creating a Tabular Report
6 Lectures 16:51

Report Wizard will not automatically format the column width to fit the header or the data.

Formatting Column Headers
03:17

SSRS provides a mechanism to change the data from the sort order provided by the report query.

Interactive Sorting
02:35

Within the report, fields can be calculated using the data returned from the query using SSRS built-in fields, Expressions or a combination of all three. Expressions will allow for greater flexibility in the display of data and formatting.

Adding Calculated Fields and Using Expressions
02:49

The formatting of cells in SSRS is similar to formatting cells in Excel. Most of the terminology is the same.

Formatting Cells
03:18

Your organization's report server should be controlled by your database administrator and quite possibly by your network administrator.

Viewing the Report on the Report Server
03:26

Just because the report displays nicely on the screen does not mean the report is formatted properly on paper.

Formatting the Report for Printing
01:26
+
Formatting of Report Headers and Footers
5 Lectures 10:18

Report Wizard does not automatically add a header and footer to the report. We will have to add them manually.

Adding the Header and Footer
02:04

There are numerous built-in fields that come with SSRS. We can add these to the header or footer so that it helps the viewer to navigate the report.

Using the Built-in Fields
02:35

Adding query-defined fields to a report can be tricky, especially if more than one row is returned.

Adding Query-Defined Fields
02:15

An organization's logo in the header of the report makes a report look official.

Adding Images to the Header
01:45

Printed reports still remain a security issue when confidential information is contained within these reports. For printed reports, metadata can be used to identify who accessed the data, when the data on the report was last updated, and when they accessed the data.

Preview 01:39
+
Creating a Drilldown Report
5 Lectures 09:57

It is important to write queries that take advantage of the database server's processing power, especially for drilldown reports.

Queries Specialized for Drilldown Report
02:19

With a well-written query, Report Wizard can efficiently create a drilldown report that will minimize the development effort.

Creating the Drilldown Report
02:15

The symbols to the left of the tablix related to the row groups below the report in the Design mode.

Grouping in SSRS
02:03

By default, the groups are collapsed.

Toggling the Display
01:31

The grand total of rows and columns can be added to drilldown reports.

Preview 01:49
+
Using Parameters in a Report
4 Lectures 11:39

The different parameter types affect the behavior of the report and the way in which the user interacts with the report.

Parameter Types
03:59

Setting available parameter values and default values reduces the likelihood of a user creating a report with unintended data. As report developers, building this robustness in the report is beneficial to the user and us.

Available and Default Values
03:18

Parameters can allow the user to change the data displayed in the report without changing the report query. Defining a parameter alone will not impact what data is displayed on the report. Filters can be created that utilize the defined parameters.

Filtering by the Parameter Value
01:52

If we export the report to a PDF or print the report, the parameter value is not displayed. We need to display the parameter value so that the user will know what parameter value was used to generate the report.

Preview 02:30
+
Creating a Drillthrough Report
4 Lectures 11:34

Drillthrough reporting requires a parent report and a child report. The child report contains additional details about an item found in the parent report.

Creating a Drillthrough Report
03:17

The child report needs to display only the data associated with the item in the parent report. Report parameters can be used in the report query's WHERE clause. In SQL Server Reporting Services, a report parameter is a separate entity from a query parameter.

Adding a Parameter to a Query
02:56

The text box of the item of interest in the parent report must be enabled to allow drillthrough actions to occur. The child report for drillthrough purposes must already exist.

Configuring the Drillthrough Reporting Action
03:00

Both the parent and the child reports in drillthrough reporting must be deployed together for the proper operation of the reports.

Preview 02:21
+
Creating Pie and Bar Charts
5 Lectures 13:17

Pie chart queries need to return labels, counts, and percentages. The percentages in the pie chart queries need to add up to 100 percent. Bar chart queries need to return a label and a numeric value.

Queries Optimized for Pie Charts and Bar Charts
02:56

Pie charts are an excellent way to demonstrate how data is distributed by percentage across different categories.

Creating the Pie Chart Report
01:50

A bar chart is an excellent way to show two-dimensional data when you have a few data points. The SSRS Bar Chart shares many properties and attributes with the Column Chart.

Creating the Bar Chart Report
01:40

There are a myriad of ways to configure report legends, titles, labels and other properties for chart objects.

Formatting the Legends and Labels
03:57

SSRS report definitions are reusable objects which may be embedded into other reports as subreports.

Preview 02:54
+
Utilizing Gauges, Sparklines, and Indicators
5 Lectures 11:51

Gauges, sparklines, and indicators are report objects in SSRS which provide an impressive way to display summarized information for presentations, documents, and web pages. Each object requires specific data elements for proper operation and to give the user the scope of the data.

Queries Optimized for Gauges, Sparklines, and Indicators
01:53

Gauges are an excellent way to show progress towards a numeric goal.

Creating a Report Containing a Gauge
02:20

Sparklines can help add a historical perspective to numbers displayed in a table.

Creating a Report Containing a Sparkline
01:58

SSRS indicators are an excellent way to show progress towards a categorical goal or the current status of a process.

Creating a Report Containing an Indicator
03:04

Dashboards allow for online reporting of high-level information to allow management to quickly find where the business is performing well and where attention is needed..

Preview 02:36
About the Instructor
Packt Publishing
3.9 Average rating
4,070 Reviews
32,656 Students
318 Courses
Tech Knowledge in Motion

Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.

With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.

From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.

Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.