New Linked Report Page (Report Manager)

Use the New Linked Report page to create a linked report. A linked report is a report with settings and properties of its own, but links to the report definition of another report. Linked reports are useful when you have a base report that you want to vary for specific groups or users; for example, a regional report that returns different data based on a regional code. A linked report is typically created from a parameterized report when you want to vary and then save different parameter values with each report instance. However, you can create a linked report from any report to which you have access.

A linked report can have its own name, description, location, parameter properties, report execution properties, report history properties, permissions, and subscriptions. However, a linked report must use the data source properties of the base report that provides the report definition.

To open this page, open the General properties page for the report upon which you want to base the linked report, click the Properties tab at the top of the page, and then click Create Linked Report.

Options

  • Name
    Specify the name of the linked report. A name must contain at least one alphanumeric character. It can also include spaces and certain symbols. However, you must not use the characters ; ? : @ & = + , $ / * < > | " or / when specifying a name.
  • Description
    Type a description of the report contents. This description appears in the Contents page to users who have permission to access the report.
  • Location
    Specify the folder path that contains the report. By default, linked reports are created as siblings to the base report. Click Change Location to put the linked report in a different folder.
  • OK
    Click OK to save your changes and return to the General properties page of the base report.

See Also

Reference

General Properties Page (Reports, Report Manager)
Report Manager F1 Help

Other Resources

Adding, Modifying, and Deleting Linked Reports
Linked Reports

Help and Information

Getting SQL Server 2005 Assistance