Databases Reference
In-Depth Information
Linked reports
This particular topic really belongs to Chapter 4 , Working with Report Manager , but is
placed here because report authoring except through SSDT was not described earlier.
A report to be linked must be kept on a server and the users can access the report
on the server. The linked report is a parametric report. When you create a linked
report from it, it can be viewed by the user who provides the parameter. In Report
Manager, it is very easy to customize the linked report depending on the folder in
which it is placed. The layout and data source properties are kept the same, but
other properties such as security, location, subscription, and so on, can be managed
from Report Manager.
Hands-on exercise 5.7 - creating linked
reports
Following are the steps to create linked reports:
1.
Create three folders on Report Manager: Global , France , and Germany .
2.
Using Report Builder, create a parametric report named qryCountry using
the following query:
SELECT TOP 1000 [CustomerID],[CompanyName],[City],[Country],[Phone]
FROM [Northwind].[dbo].[Customers]
WHERE Country=@country
3.
Save this report to the Global folder on the Report Server.
4.
Return to Report Manager, open Global and click on the report to
manage the report saved in the folder in the previous step, as shown
in the following screenshot:
 
Search WWH ::




Custom Search