How to Use Subreports and Nested Regions in SQL Server


show more A subreport is a report that has been nested inside of another report in your SQL Server. This type of interactive subreporting lets you expand a nested region of the report for further data and analysis. Learn how using subreports and nested regions can add depth to your reports for better decision making. show less
please wait ...

Using subreports and nested regions

Earlier in the course, I showed how we could create reports that used parameters; either typing in a value or having perhaps a dropdown selection would allow you to refresh the data based on that selection. Another way of doing this is using what's called a drillthrough report, so we could use an action to drill from one report to another. But another way of connecting reports is to use a feature called subreport, literally one report nested inside another. Now, the typical example is that we have a report like this one. I called it parameter example.

It's a report that accepts a parameter and can change what it's showing based on that parameter. But if I think this will be useful, I want to see it contained inside a larger report. So I'm going to jump over to Report Builder and do that. I've created a blank report here I've called Categories and Products, and to save some time I'll got a connection to AdventureWorksLT and a very simple dataset that is currentl...

Using subreports and nested regions
Video duration: 4m 28s 3h 44m Advanced

Viewers:

A subreport is a report that has been nested inside of another report in your SQL Server. This type of interactive subreporting lets you expand a nested region of the report for further data and analysis. Learn how using subreports and nested regions can add depth to your reports for better decision making.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...