| Description |
1 online resource (818 pages) |
| Contents |
Cover; Title Page; Copyright; About the Author; About the Technical Editor; Credits; Acknowledgments; Contents; Foreword; Foreword; Introduction; Who This Book is For; What This Book Covers; Part I: Getting Started; Part II: Basic Report Design; Part III: Advanced and Analytic Reporting; Part IV: Solution Patterns; Part V: Reporting Services Custom Programming; Part VI: Mobile Report Solutions; Part VII: Administering Reporting Services; What You Need to Use This Book; Conventions; Sample Reports and Projects; Errata; P2P. WROX.COM; Part I: Getting Started |
|
Chapter 1: Introducing Reporting ServicesWho Uses Reporting Services?; Information Workers and Data Analysts; Information Consumers; Business Managers and Leaders; Software Developers; System Administrators; Dashboards, Reports, and Applications; Application Integration; Business Intelligence and Analytics Solutions; Mobile Reports and KPIs; Report Tool Choices; Simple Report Design; IT-Designed Reports; User-Designed Reports; Server-Based Reports; Report Data Sources; Enterprise Scale; Optimizing Performance; Performance; Summary; Chapter 2: What's New in SQL Server 2016 Reporting Services? |
|
Report Builder and Designer EnhancementsModern Browser Rendering; Parameter Layout Control; Updated RDL Specification; Mobile Reports; KPIs; Native Printing Control; PowerPoint Rendering; Integrated and Improved Web Portal; New Charts and Visual Enhancements; Standardized, Modern Browser Rendering; Power BI Dashboard Pinning; Summary; Chapter 3: Reporting Services Installation and Architecture; What's Changed in SQL Server 2016?; The Basic Installation; Installing Reporting Services; Installing the Reporting Services Samples, Exercises, and SQL Server Databases; The Enterprise Deployment |
|
SQL Server EditionsDefault and Named Instances; Topology; Modes; Installation Options; The Reporting Life Cycle; Authoring; Management; Delivery; Reporting Services Tools; Report Builder; Web Portal; SharePoint Libraries and Web Parts; Reporting Services Configuration Manager; SQL Server Management Applications; Command-Line Utilities; HTML Viewer; Report Viewer Control; Reporting Services Web Service; Reporting Services Windows Service; HTTP. SYS and the HTTP Listener; The Security Sublayer; Web Portal and the Web Service; Core Processing; Service Management; WMI and the RPC Interface |
|
Reporting Services Processors and ExtensionsThe Report Processor; Data Processing Extensions; Report Items; Rendering Extensions; The Scheduling and Delivery Processor; Delivery Extensions; Reporting Services Application Databases; ReportServer; ReportServerTempDB; Summary; Part II: Basic Report Design; Chapter 4: Report Layout and Formatting; Using Report Design Tools; Understanding Report Data Building Blocks; Data Sources; Datasets; Data Regions; Report Items; Samples and Exercises; Preparing the Report Data; Designing the Report Layout; Reviewing the Report; Setting Formatting Properties |
| Summary |
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 |
| Notes |
Validating Report Design and Grouping Data |
|
Print version record |
| SUBJECT |
SQL server. http://id.loc.gov/authorities/names/n90684343
|
|
SQL server. fast (OCoLC)fst01376937 |
| Form |
Electronic book
|
| Author |
Finlan, Christopher
|
|
Muti, Riccardo
|
| ISBN |
9781119258360 |
|
1119258367 |
|
