XSLT with xmlns

Question

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

Answer 1

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

Answer 2

http://stackoverflow.com/questions/1190734/xslt-on-ssrs-report

maybe this link will give some assistance.

regards

joon