Professional SSRS 2016 Preview: Chapter 5 – Data Access & Query Basics

This post is part of the series: “Professional SSRS 2016 Book Preview Posts” which are 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.  The goal for this posts is to provide useful and meaningful information you can use.  For more comprehensive details, I refer readers to the rather lengthy book itself.  Note that large portions are copied directly from the book manuscript that may refer to figures and screen capture images that have been removed for brevity.

  • 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

Data source queries are the foundation of reporting and writing effective queries and are essential to design.

Continue reading

Professional SSRS 2016 Preview: Chapter 4 – Basic Report Design

This post is part of the series: “Professional SSRS 2016 Book Preview Posts” which are 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.  The goal for this posts is to provide useful and meaningful information you can use.  For more comprehensive details, I refer readers to the rather lengthy book itself.  Note that large portions are copied directly from the book manuscript that may refer to figures and screen capture images that have been removed for brevity.

  • 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

Report design is both a science and an art. It is a science because there are definitely standard and repeatable methods for designing common report types.

Continue reading

Professional SSRS 2016 Preview: Chapter 3–Reporting Services Installation and Architecture

This post is part of the series: “Professional SSRS 2016 Book Preview Posts” which are 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.  The goal for this posts is to provide useful and meaningful information you can use.  For more comprehensive details, I refer readers to the rather lengthy book itself.  Note that large portions are copied directly from the book manuscript that may refer to figures and screen capture images that have been removed for brevity.

    WHAT’S IN THIS CHAPTER

  • 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

Continue reading

Professional SSRS 2016 Preview: Chapter 2–What’s New in SQL Server 2016 Reporting Services?

This post is part of the series: “Professional SSRS 2016 Book Preview Posts” which are 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.  The goal for this posts is to provide useful and meaningful information you can use.  For more comprehensive details, I refer readers to the rather lengthy book itself.  Note that large portions are copied directly from the book manuscript that may refer to figures and screen capture images that have been removed for brevity.

WHAT’S IN THIS CHAPTER

  • 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

Continue reading