Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Optimize reporting and BI with Microsoft SQL Server 2016

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You’ll learn effective report solution design based upon many years of experience with successful report solutions. Improve your own reports with advanced, best-practice design, usability, query design, and filtering techniques. Expert guidance provides insight into common report types and explains where each could be made more efficient, while providing step-by step instruction on Microsoft SQL Server 2016. All changes to the 2016 release are covered in detail, including improvements to the Visual Studio Report Designer (SQL Server Data Tools) and Report Builder, Mobile Dashboard Designer, the new Report Portal Interface, HTML-5 Rendering, Power BI integration, Custom Parameters Pane, and more.

The Microsoft SQL Server 2016 release will include significant changes. New functionality, new capabilities, re-tooled processes, and changing support require a considerable update to existing knowledge. Whether you’re starting from scratch or simply upgrading, this book is an essential guide to report design and business intelligence solutions.

• Understand BI fundamentals and Reporting Services architecture
• Learn the ingredients to a successful report design
• Get up to speed on Microsoft SQL Server 2016
• Grasp the purpose behind common designs to optimize your reporting

Microsoft SQL Server Reporting Services makes reporting faster, easier, and more powerful than ever in web, desktop and portal solutions. Compatibility with an extensive variety of data sources makes it a go-to solution for organizations across the globe. The 2016 release brings some of the biggest changes in years, and the full depth and breadth of these changes can create a serious snag in your workflow. For a clear tutorial geared toward the working professional, Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports is the ideal guide for getting up to speed and producing successful reports.

Table of Contents

PART I GETTING STARTED
CHAPTER 1 Introducing Reporting Services
CHAPTER 2 What’s New in SQL Server 2016 Reporting Services?
CHAPTER 3 Reporting Services Installation and Architecture

PART II BASIC REPORT DESIGN
CHAPTER 4 Report Layout and Formatting
CHAPTER 5 Data Access and Query Basics
CHAPTER 6 Grouping and Totals

PART III ADVANCED AND ANALYTIC REPORTING
CHAPTER 7 Advanced Report Design
CHAPTER 8 Graphical Report Design
CHAPTER 9 Advanced Queries and Parameters
CHAPTER 10 Reporting with Analysis Services
CHAPTER 11 SSAS Reporting Advanced Techniques
CHAPTER 12 Expressions and Actions

PART IV SOLUTION PATTERNS
CHAPTER 13 Report Projects and Consolidation
CHAPTER 14 Report Solutions, Patterns, and Recipes

PART V REPORTING SERVICES CUSTOM PROGRAMMING
CHAPTER 15 Integrating Reports into Custom Applications
CHAPTER 16 Extending Reporting Services

PART VI MOBILE REPORT SOLUTIONS
CHAPTER 17 Introducing Reporting Services Mobile Reports
CHAPTER 18 Implementing a Mobile Report with
Design-First Development
CHAPTER 19 Mobile Report Design Patterns
CHAPTER 20 Advanced Mobile Report Solutions

PART VII ADMINISTERING REPORTING SERVICES
CHAPTER 21 Content Management
CHAPTER 22 Server Administration