Hi All I'm creating an XML file using SSRS. I get the output. But since I need custom fields, I have been trying to use it with XSLT. The transformations work partially, any fail for most of the tags since the XML generated by SSRS has got xmlns in it. XML: <?xml version="1.0" encoding="utf-8"?> <?xml-stylesheet type="text/xsl" href="AMTS.xsl"?> <Report xsi:schemaLocation="AMTS http://reportserver?%2FAMTS&amp;rs%3AFormat=XML&amp;rc%3ASchema=True" Name="AMTS" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="AMTS"> <LName>DATA</LName> <TAG1><TAG2><TAG3><TAG4>DATA</TAG4><TAG5>DATA</TAG5></TAG3> <TAG3><TAG4>DATA</TAG4><TAG5>DATA</TAG5></TAG3></TAG2></TAG1> </Report> How would my XLST should be. The XML would have 1 LName and multiple TAG3 tags ? Thanks

Hello pagcts, Thank you to post your question on TechNet forum. From your description, I am not very clear what you mean "The XML would have 1 LName and multiple TAG3 tags". Can you post out the input and expected output? Regards, Edward TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here. Edward Zhu TechNet Community Support

http://stackoverflow.com/questions/1190734/xslt-on-ssrs-report maybe this link will give some assistance. regards joon