UFN_REPORT_ISCHECKREPORT

This function validates whether the report record is a check report.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@REPORTCATALOGID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_REPORT_ISCHECKREPORT(@REPORTCATALOGID uniqueidentifier)
      returns bit
            with execute as caller
            as begin

            if exists(
                select
                    ID
                from
                    dbo.REPORTCATALOG R
                where
                    R.ID = @REPORTCATALOGID
                    and R.REPORTSPECXML.value('(/)[1]', 'nvarchar(max)') like '%Check Reports%'
            ) return 1;

            return 0;
end