Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Creating Reports with SQL Server 2012 Reporting Services
  • Table Of Contents Toc
Creating Reports with SQL Server 2012 Reporting Services

Creating Reports with SQL Server 2012 Reporting Services

By : Dallas Harold Snider
Buy this Video
close
close
Creating Reports with SQL Server 2012 Reporting Services

Creating Reports with SQL Server 2012 Reporting Services

By: Dallas Harold Snider
Buy this Video

Overview of this book

Our Creating Reports with SQL Server 2012 Reporting Services course equips you with the skills to design and deploy robust reports using SSRS. From understanding data sources and report queries to formatting, parameterization, and creating visualizations like charts and gauges, this course covers it all. Learn to create tabular, matrix, drilldown, and drillthrough reports, and elevate your reporting capabilities to the next level.
Table of Contents (8 chapters)
close
close
close
1
The Report Wizard
Icon
Data Sources
Icon
Report Queries
Icon
Tabular Report Types and Their Configuration
Icon
Matrix Report Types and Their Configuration
Icon
Deployment Location and Completing the Wizard
2
Creating a Tabular Report
Icon
Formatting Column Headers
Icon
Interactive Sorting
Icon
Adding Calculated Fields and Using Expressions
Icon
Formatting Cells
Icon
Viewing the Report on the Report Server
Icon
Formatting the Report for Printing
3
Formatting of Report Headers and Footers
chevron up
Icon
Adding the Header and Footer
Icon
Using the Built-in Fields
Icon
Adding Query-Defined Fields
Icon
Adding Images to the Header
Icon
The Importance of Displaying Report Metadata on the Report
4
Creating a Drilldown Report
Icon
Queries Specialized for Drilldown Report
Icon
Creating the Drilldown Report
Icon
Grouping in SSRS
Icon
Toggling the Display
Icon
Adding Summary Rows
5
Using Parameters in a Report
Icon
Parameter Types
Icon
Available and Default Values
Icon
Filtering by the Parameter Value
Icon
Displaying Parameter Values within the Report
6
Creating a Drillthrough Report
Icon
Creating a Child Report
Icon
Adding a Parameter to a Query
Icon
Configuring the Drillthrough Reporting Action
Icon
Deploying the Drillthrough Reports to the Report Server
7
Creating Pie and Bar Charts
Icon
Queries Optimized for Pie Charts and Bar Charts
Icon
Creating the Pie Chart Report
Icon
Creating the Bar Chart Report
Icon
Formatting the Legends and Labels
Icon
Placing two Subreports onto One Report
8
Utilizing Gauges, Sparklines, and Indicators
Icon
Queries Optimized for Gauges, Sparklines, and Indicators
Icon
Creating a Report Containing a Gauge
Icon
Creating a Report Containing a Sparkline
Icon
Creating a Report Containing an Indicator
Icon
Creating a Dashboard
You're currently viewing a free sample. Access the full title and Packt library for free now with a free trial.
Chapter: 3
Formatting of Report Headers and Footers
Icon This video is locked
Icon
Icon
0:00
2.0x
1.5x
1.25x
1.0x
0.5x
caption settings
caption off
Icon Icon
ShowHide Transcripts Icon
Section: 3
Adding Query-Defined Fields
Adding query-defined fields to a report can be tricky, especially if more than one row is returned. - Add a new dataset with the query to return a single row of data - Add values from this new dataset to the header - Format the new field and preview to test
CONTINUE WATCHING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Creating Reports with SQL Server 2012 Reporting Services
End of Section 3
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options
font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon