O'Reilly logo

SQL Server 2016 Reporting Services Cookbook by Robert C. Cain, Dinesh Priyankara

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with published report parts

In addition to entire reports, Report Builder allows you to publish parts of a report. Components that are eligible to become a report part include:

  • Charts
  • Gauges
  • Images (and embedded images)
  • Maps
  • Parameters
  • Rectangles
  • Tables
  • Matrices
  • Lists

By creating report parts, users can integrate these into their own reports to create SSRS reports that have the design of a dashboard.

Getting ready

We will reuse the report created in this chapter How to design reports manually recipe. It included a chart that we will publish as a part and then import into a second report. Be sure you have created this report and have it available to use in this recipe.

How to do it...

  1. In Report Builder, open Report 04-02.rdl.
  2. In the View tab, place a ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required