bo (5/8/2008)
Thank you for your posting, it is very helpful. Just want to point out when setting the return value of the function to the dataset parameter, it needs to reference the Code class(i.e. =Code.ReturnXML(....)).
good point.
If you're using the function in the Code tab of the report properties, it gets referenced as:
=Code.ReturnXML(...)
If you're using the function in an assembly, it gets referenced as:
=LibraryName.ClassName.ReturnXML(...)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes