Hi I am trying to export SSRS report data to XML and transform it using XSLT. When I tested on my DEV machine I need to put name space prefix. While I deploy it to UAT I have to remove all name space prefix from XML tag to get proper transformed output. So that give me a hard time to release the same XSLT file to different environments. And I can't seen to find any option/configuration item for that. If any of you has any information regarding that, could you please shed some light? Thanks XML report data <?xml version="1.0" encoding="utf-8"?> <Report xsi:schemaLocation="Report http://localhost:8777/ReportServer?%2fTestReport%2fReport&amp;rs%3aCommand=Render&amp;rs%3aFormat=XML&amp;rs%3aSessionID=ccdk1r55c0yse245qto1zdyv&amp;rc%3aSchema=True" Name="Report" textbox1="Report" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="Report"> XSLT with name space prefix <?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:rpt="Report" > <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no" omit-xml-declaration="no"/> <xsl:template match="/rpt:Report"> XSLT without name space prefix <?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:rpt="Facilitation" > <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no" omit-xml-declaration="no"/> <xsl:template match="/Report">

Hi lordwho, Based on the information, my understanding to this issue is as follows, We have developed a report, and then export the data to a XML file. Then, you are trying to transform it to a formated output with XSLT. In different environment (development or production), we have to use different XSLT file to transform the same XML file, right? If that is the case, I think you need to ask XML experts instead of Reporting as the Data Source has been exported to the XML file successfully. You may refer to following forum, XML, System.Xml, MSXML and XmlLite: http://social.msdn.microsoft.com/Forums/en-US/xmlandnetfx/threads From my view point, the two XSLT has two different value for xmlns:rpt, maybe you can try to set them to the same value and see if it helps. Thanks, Eileen