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.



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.


Artificial Intelligence: Problems and their solutions

Authors: Danny Kopec, Shweta Shetty and Christopher Pileggi
Publisher: Mercury
Pages: 300
ISBN: 978-1938549830
Audience: People interested in puzzles and AI.
Rating: 3
Reviewer: Mike James 

A book with companion CD-ROM that solves AI problems - sounds just what the AI expert ordered!

Agile Project Management with Kanban

Author: Eric Brechner
Publisher: Microsoft Press
Date: February 25, 2014
ISBN: 97807356989536
Print: 0735698953
Kindle: B00U017N4A
Audience: Managers and teams looking to improve productivity
Rating: 5
Reviewer: Andrew Johnson 

Is Kanban a good technique for you? Read this book to  [ ... ]

More Reviews



Last Updated ( Friday, 21 April 2017 )

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