O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

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

Adding a subreport

Our next step is to embed the Sales Order Detail report into the Sales Order Header report.

  1. Open the first report, Sales Order Header Report, if you've already closed it.

    Note

    Underlying processes are needed to run a subreport on top of the process needed to run the main report. That usually means additional load on the report server. Additional loads like that impact the performance of your report. Remember that the subreport is run as a separate report.

  2. Let's drag a Subreport object into the middle portion of the body of our report (on top of the line). Resize accordingly.

    You'll have something like the following:

    Adding a subreport
  3. Let's configure ...

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