Revision: 45373
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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