Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports
Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Author: Paul Turley
Publisher: Wrox Press
Date: January 2017
Pages: 816
ISBN: 978-1119258353
Print: 1119258359
Kindle: B01N12MHZU
Audience: Database developers
Rating: 4.5
Reviewer: Kay Ewbank

This is a new fifth edition of a very successful book on Reporting Services, updated to cover the changes in SQL Server 2016, including the introduction of Mobile Report Services. 

The book opens with chapters introducing Reporting Services and what's new in SQL Server 2016 Reporting Services. It then moves on to a section on basic report design, with coverage of layout and formatting, data access and query basics, and grouping and totals.

 

Banner

For most developers, the useful part of the book starts next, in the section on advanced and analytic reporting. There are chapters on advanced report design covering aspects such as headers and footers, embedded formatting,and different types of master/detail reports. A chapter on graphical report design introduces the use of charts in reports, and looks at the different types of charts supported by Reporting Services.

Advanced queries and parameters are covered next, beginning with T-SQL queries and parameters, then MDX queries and parameters. In both cases the emphasis is on how to use the queries within reports rather than how to write advanced queries.

Next comes a chapter on reporting with analysis services, looking at working with MDX, non-additive measures, cube formatting and drill-through reports. I think this is where Reporting Services starts to get both useful and more difficult to understand, and while the chapter has useful explanations, I think even more in-depth descriptions would still be useful.

The next chapter does move on to Analysis Services advanced techniques, and again has useful explanations. It shows how to build a dynamic cube browser with SSRS, how to work with dynamic rows, restrict rows, work with cube metadata, all the way to the cube browser. A chapter on using the expression builder and actions brings this section of the book to a close.

 

 

The title of the next part of the book is 'solution patterns', and it begins with a meaty chapter on report projects and consolidation. This introduces the use of SSDT (SQL Server Data Tools for Visual Studio), and how to use it, along with how to manage version control for reports, synchronizing content, and planning a self-service reporting environment. The next chapter is based on talks given by the author at the PASS Global Summit, and introduces the idea of a super report that can be used to provide customized information relevant to different groups of users. Various 'report recipes' that back this up are also introduced.

The book now moves on to custom programming with Reporting Services, with chapters on integrating reports into custom applications, and extending Reporting Services. The chaper on integrating reports into custom apps shows how to use URLs to access reports via HTTP; using the Reporting Services web services to render reports; and using the ReportViewer controls.

Extending Reporting Services shows how to use the Data Processing Extensions, and how to create your own custom data processing extension.

Te next section is completely new, an addition from earlier editions of the book. It covers the mobile reporting features added in SQL Server 2016. There are chapters on the Mobile Report Publisher, how to design and implement a mobile report, and advanced reporting covering aspects such as the chart data grid, dataset parameters, and drill through to paginated reports. 

The final section of the book covers administering Reporting Services.

This is a very thorough book, covering Reporting Services in depth. It's not a book for the beginner, and some aspects receive less coverage than would be ideal. Fortunately, the author concentrates on the more advanced areas, which is where you really need the information.

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on, Twitter, FacebookGoogle+ or Linkedin.

Banner


Modern Web Development

Author: Dino Esposito
Publisher: Microsoft Press
Pages: 448 
ISBN: 978-1509300013
Print: 1509300015
Kindle: B01C33LL6I
Audience: ASP .NET developers
Rating: 5
Reviewer: Mike James

Modern web development from a Microsoft point of view is a mystery to many. Can this book  [ ... ]



SQL Server 2016 Developer's Guide

Author: Dejan Sarka et al
Publisher: Packt Publishing
Pages: 616
ISBN: 978-1786465344
Print: 1786465345
Kindle: B01MS5L01Q
Audience: SQL Server devs & architects
Rating: 4.8
Reviewer: Ian Stirk

This book aims to introduce you to the salient new and enhanced features in SQL Server 2016, how [ ... ]


More Reviews

 

 

Last Updated ( Friday, 21 April 2017 )
 
 

   
Banner
RSS feed of book reviews only
I Programmer Book Reviews
RSS feed of all content
I Programmer Book Reviews
Copyright © 2017 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.