Chapter 13Report Projects and Consolidation

How to best structure the work in a manner that is both consistent and logical is the first decision facing a report solution developer. In like manner, this becomes particularly important when working as part of a project team; each team member is responsible for delivering a piece of the overall solution.

The chapter looks at ways to organize your report development, and support the full deployment life cycle from requirements to production implementation.

The Reporting Services product has expanded to include different categories of reports, which provides greater opportunity to support different types of reporting scenarios. This also adds to the potential confusion of choices and solution approaches for those architecting and managing solutions and supporting report users. In brief, the Reporting Services umbrella encompasses the following reporting scenarios:

  • Paginated Reports—Conventional SQL Server Reporting Services (SSRS) reports are designed and delivered by the IT organization to the business user community. These reports are typically designed using patterns similar to software development projects, starting with business ...

Get Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.