USP_REPORTLINK_GETLISTFORREPORT

Returns a list of all reports linked to a given base report.

Parameters

Parameter	Parameter Type	Mode	Description
@REPORTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_REPORTLINK_GETLISTFORREPORT(@REPORTID uniqueidentifier)
as
set nocount on;

    select ID, REPORTSPECXML
    from REPORTCATALOG
        where REPORTSPECXML.value
        (
            N'declare namespace bbspec="bb_appfx_report";
            /bbspec:ReportSpec[1]/bbspec:LinkedReport[1]/@BaseReportID',
            'uniqueidentifier'
        ) = @REPORTID;