Create a Linked Report in an SQL Server Database


show more A report is a way to present data as a visual representation, and a linked report creates a shortcut to specific information within the report. With SQL, you can create reports that share information from different areas, such as sales numbers from a particular region. This online video guides you through the step-by-step process of creating a linked report. show less
please wait ...

Creating a linked report

One of the options you might have seen in Report Manager when using this dropdown menu is to create a linked report. A linked report saves us from the situation where we might have to define exactly the same report several times over only to show a little bit of different data. So, say I created a great complex report filtered to just the data from the southwest region, and then someone looks at it and says they want exactly the same thing, but for the northeast region. I don't have to create the report again. I just create a linked report and point it to slightly different data.

So, let's go ahead and make one. The starting point is this. I've just created for myself a simple report called WashingtonPeople. It shows the Salespeople data filtered down to Washington. Okay, I have done it as something that's very easy to understand, but let's imagine that this was a lot more complex--historical data, charts, maps, matrices and sparklines--a work of genius report, but just ...

Creating a linked report
Video duration: 4m 8s 3h 44m Advanced

Viewers:

A report is a way to present data as a visual representation, and a linked report creates a shortcut to specific information within the report. With SQL, you can create reports that share information from different areas, such as sales numbers from a particular region. This online video guides you through the step-by-step process of creating a linked report.

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