Create a Drillthrough Action to Connect SQL Server Reports


show more A drillthrough is a separate report that opens when you click a link in the first report in your SQL Server. It allows you to jump back and forth easily from section to section. This online video will teach you about this advanced technique and show you how to create a drillthrough action to connect reports. show less
please wait ...

Creating a drillthrough action to connect reports

In Reporting Services it's often useful to create one report that links to another. Earlier, I'd created a report that listed products based on a particular category, and I used this example to show parameters being used. Now, we just developed this as a stand- alone report, and it works great like this, but there's another thing we can do with it. We can create a new report that jumps directly into this one. And because this report accepts a parameter, we can pass a parameter directly into it. This is what's known as a drill-through action.

So to do this I'm going to create a new report. Once again, I'll just do a blank report here, add a data source pointing to AdventureWorksLT, and now I'm going to add a dataset, call this Categories. And from this, I'll drill down into the ProductCategory table and just get ProductCategoryID and Name. There is nothing special about what I'm doing up to this point. I'm creating a normal data source, normal dataset...

Creating a drillthrough action to connect reports
Video duration: 4m 26s 3h 44m Advanced

Viewers:

A drillthrough is a separate report that opens when you click a link in the first report in your SQL Server. It allows you to jump back and forth easily from section to section. This online video will teach you about this advanced technique and show you how to create a drillthrough action to connect reports.

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