Forum Replies Created

Viewing post 1 (of 1 total)

  • Reply To: Print the selected database from datasource on reporting services report

    ;WITH XMLNAMESPACES -- XML namespace def must be the first in with clause.

    (DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2006/03/reportdatasource'

    ,'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'

    AS rd)

    ,SDS AS

    (SELECT SDS.ItemID, SDS.[Path], SDS.[Name] AS SharedDsName, SDS.ParentID, SDS.[Type], SDS.Content,

    CONVERT(xml, CONVERT(varbinary(max), SDS.content)) AS DEF, SDS.LinkSourceID

    FROM dbo.[Catalog]...

Viewing post 1 (of 1 total)