Return to Snippet

Revision: 45373
at April 29, 2011 02:02 by michanne


Initial Code
declare @reportname varchar(500) = 'New PRD by Agency', @parm xml;

select @parm = convert(xml,parameter) --as p, c.Name, c.Description,Path
from dbo.Catalog c
where Name = @reportname

select c.Name as ReportName,Description,Path,
ParmValues.Parameter.value('(./Name)[1]','Varchar(100)')as ParamName,
ParmValues.Parameter.value( '(./Type)[1]','varchar(100)') as DataType,
ParmValues.Parameter.value( '(./Nullable)[1]','bit') as Nullable,
ParmValues.Parameter.value( '(./AllowBlank)[1]','bit') as AllowBlank,
ParmValues.Parameter.value( '(./MultiValue)[1]','bit') as MultiValue,
ParmValues.Parameter.value( '(./UsedInQuery)[1]','bit') as UsedInQuery,
ParmValues.Parameter.value( '(./Prompt)[1]','varchar(100)') as Prompt,
ParmValues.Parameter.value( '(./PromptUser)[1]','bit') as PromptUser,
ParmValues.Parameter.value( '(./DynamicDefaultValue)[1]','bit') as DynamicDefaultValue
from dbo.Catalog c
join @parm.nodes('//Parameter') as ParmValues(Parameter) on c.Name = @reportname

Initial URL

                                

Initial Description

                                

Initial Title
SSRS Report Parmeters and description

Initial Tags

                                

Initial Language
SQL