Advanced Search

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