Book Image

Reporting with Microsoft SQL Server 2012

Book Image

Reporting with Microsoft SQL Server 2012

Overview of this book

Table of Contents (12 chapters)

Report development environment


There are two primary tools for report authors to use in creating SSRS reports: Report Builder and Report Designer.

  • Report Builder: This is a standalone application offering a simplistic design experience and targeted at power users. This tool provides a familiar office-ribbon user interface and provides a wizard to guide the report author through the various report development tasks. It can also be used to easily edit existing reports that have been deployed to the report server.

  • Report Designer: This is a fully featured report authoring tool based on Visual Studio and targeted at IT developers. Compared to Report Builder, this tool offers a much more manual development experience but can prove to be overly complicated for typical power users.

Feature-wise there is little difference between these two tools other than the ability to consume Shared Report Parts. Report Builder can be used to create and consume Shared Report Parts, while Report Designer can only...