Author Topic: Find List of Parameters from Report Server database  (Read 2003 times)

BhushanShah

  • Global Moderator
  • Jr. Member
  • *****
  • Posts: 73
  • BhushanShah21
    • View Profile
Find List of Parameters from Report Server database
« on: March 18, 2013, 04:58:56 PM »
You can Find List of Parameters from Report Server database with the help of following Query :

Code: [Select]
WITH cte AS (
    SELECT   CAST(parameter AS XML) AS parameter,Name
    FROM     [dbo].[Catalog] AS c
)
SELECT  Name,p.value('(./Name)[1]', 'nvarchar(50)')as Parameter
FROM    cte AS c
CROSS APPLY c.Parameter.nodes('/Parameters/Parameter') AS T ( p )
WHERE NAME = @ReportName
Regards,
Bhushan Shah