This page is a table of contents for for several new and forthcoming posts. I’m posting a series of excerpts for my Wrox Press book: Professional SQL Server 2016 Reporting Services and Mobile Reports. Each of the posts is a condensed version of the material covered in a corresponding chapter from the book. Although I would love for you to buy the book to get the full edition of each topic, each post will contain valuable information that I hope will be informative and educational on it’s own; whether you buy the book or not. I’ll update this index with topics and links as I continue to add each post. Until then, some of these will serve as placeholders for future posts.
Please post comments or contact me through my blog if you have questions or feedback, or if you are interested in training and consulting related to this material. – Paul
Chapter 2 – What’s New in SQL Server 2016 Reporting Services?
- Report designer enhancements
- Modern browser rendering
- Parameter layout management
- Introducing Mobile Reports and KPIs
- New printing and rendering options
- The new web portal
- Power BI dashboard pinning and integration
Chapter 3 – Installation & Architecture
- What’s changed in SQL Server 2016?
- Installing a report server
- Building an enterprise deployment
- Using tools to manage the reporting life cycle
- Exploring report server architecture
- Leveraging reporting services extensions
Chapter 4 – Basic Report Design
- Using report design tools
- Using report data building blocks
- Preparing the report data
- Designing the report layout
- Setting formatting properties
- Validating report design and grouping data
Chapter 5 – Data Access & Query Basics
- Database and query essentials
- Understanding relational database principles and concepts
- Data source management
- Datasets and using query design tools
- Query authoring using the Report Builder query designer
- Query authoring with SQL Server Management Studio
- Using single and multi-select parameters
Chapter 6 – Grouping And Totals
- Introducing SQL Server Data Tools for Visual Studio
- Sample reports projects and exercises
- Using the graphical Query Designer
- Understanding query groups and table joins
- Understanding report data flow
- Understanding report groups
- Grasping expression basics
- Utilizing group sorting and visibility
Chapter 7 – Advanced Report Design
- Pagination, and page headers and footers
- Report headers and footers
- Text formatting and textbox properties
- Embedded formatting and HTML text styling
- Master/detail reports
- Working with subreports
- Creating a document map
Chapter 8 – Graphical Report Design
- Understanding visual design principles and the fashion of visualization
- Understanding chart types and design approaches
- Getting to know the anatomy of a chart
- Creating a multi-series chart
- Using multiple chart areas
- Learning useful properties and settings
Chapter 9 – Advanced Queries and Parameters
- Understanding T-SQL queries and parameters
- Understanding MDX queries, parameters, and expressions
- Understanding DAX queries, parameters, and expressions
- Managing report parameters
- Using parameter expressions
Chapter 10 – Reporting with Analysis Services
- Using Analysis Services for reporting
- Working with Multidimensional Expressions (MDX)
- Building queries with the MDX Query Designer
- Building queries manually
- Adding nonadditional measures
- Understanding when to use the Aggregate function
- Using MDX and drill-through reports
Chapter 11 – SSAS Reporting Advanced Techniques
- Dynamically changing report content and navigating hierarchies by changing report parameters
- Restricting the number of rows with a parameter
- Displaying and allowing users to explore cube metadata
- Creating your own cube browser in Reporting Services
Chapter 12 – Expressions and Actions
- Revisiting expressions
- Understanding calculated fields
- Using conditional expressions
- Getting to know IIF and SWITCH functions
- Using custom code
- Reporting recursive relationships
- Using actions to navigate reports
Chapter 13 – Report Projects and Consolidation
- Understanding SSDT solution patterns
- Getting to know report specifications and requirements
- Using report templates
- Understanding development phases
- Using version control
- Planning for self-service reporting
- Exploring Report Builder solutions
- Migrating self-service reports
Chapter 14 – Report Solutions, Patterns and Recipes
- Designing super reports
- Report recipes
- Dashboard solutions
- Designing a KPI scorecard
- Designing an interactive sparkline report
- Maps with navigation
Chapter 15 – Integrating Reports into Custom Applications
- Leveraging URL access and web services to render reports
- Building a custom Windows Forms application to enter parameters and render reports
- Integrating report viewer controls in Windows and Web Forms applications
- Rendering reports from within your web applications as HTML or as other downloadable formats such as PDF
- Creating custom parameter input interfaces for Reporting Services
Chapter 16 – Extending Reporting Services
- Leveraging extensibility options
- Reasons for extending SQL Server Reporting Services
- Creating custom extensions
- Installing custom extensions
- Using Mobile Report Publisher
- Designing datasets for mobile reporting
- Learn when to use mobile reports
- Understanding visual control categories
- Using design-first report development
- Creating and using shared datasets
- Using Time navigators
- Using Selectors
- Using Number gauges and charts
- Applying mobile layouts and color styling
- Deploying and testing a completed mobile report
- Introducing KPIs
- Setting KPI target, status, and trends
- Creating a time-series mobile report
- Using a Time navigator, Number gauge, and Time chart
- Implementing design-first report development
- Configuring server access
- Using reports on mobile devices
- Introducing the Chart data grid visual control
- Correlating two datasets in a control
- Using parameters in a shared dataset
- Drill through to a mobile report with dataset parameters
- Drill through to a paginated report with dataset parameters
- Adding custom maps and managing shapes
Chapter 21 – Content Management
- Using web portal
- Content management activities
- Item-level security
- Content management automation
Chapter 22 – Server Administration
- Enforcing security
- Account management and system-level roles
- Implementing surface area management
- Planning for backup and recovery
- Managing application databases
- Managing encryption keys
- Using configuration files
- Monitoring and logging
- Using performance counters and server management reports
- Understanding memory management
- Configuring URL reservations
- Administering e-mail delivery
- Managing rendering extensions
Hi Paul, do you go into much detail regarding connecting SSRS to a tabular model?
In your table of contents above it shows Chapter 9 as having “Understanding DAX queries”, yet the table of contents on the Wrox website doesn’t show this topic. http://www.wrox.com/WileyCDA/WroxTitle/Professional-Microsoft-SQL-Server-2016-Reporting-Services-and-Mobile-Reports.productCd-1119258359.html
HI Paul,
Thank you for your great post I am eagerly awaiting the official release of the book
I also noticed that you have repeated the contents of Chapter 13 and Chapter 12 probably by mistake.
Ahhhh, thank you. Much copying and pasting. I’ll get that updated.