February 18, 2015 at 2:57 pm
Hi
I am at a lost. I have an XSLT that I use to render a report when I export it in XML. It works in SSRS2008 but it is not working in SSRS2014.
I added the file name in the datatransform property of the report. I created a simple XSLT but it won't work. It is not processing the template="Report".
please help. It is not even rendering the <h2> tags. Below are sample xslt and XML.
XSLT:
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
<xsl:template match="/">
<html>
<body>
<xsl:apply-templates/>
</body>
</html>
</xsl:template>
<xsl:template match="Report">
<h2>My Header </h2>
<p><xsl:value-of select="table/Details_Collection/Details/@customer" /></p>
</xsl:template>
</xsl:stylesheet>
Sample
XML:
<?xml version="1.0" encoding="utf-8"?>
<Report xsi:schemaLocation="blank http://localhost-sql04/ReportServer?%7Cqelc4b45mm1wlp55ejszkg55%7C%40%7C%2Fctg%2Freport%7C&rs%3ACommand=Render&rs%3AFormat=XML&rs%3ASessionID=4sskagfqxdykp445v2e1nq33&rc%3ASchema=True"
Name="blank"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="blank">
<table>
<Details_Collection>
<Details customer="Arlington Memorial"
owner="Roger Preacher"
solutionname="Car"
productname="Kia Pride" />
<Details customer="Arlington Memorial"
owner="Roger Preacher"
solutionname="Car"
productname="Honda Civic" />
<Details customer="Michael De Mesa"
owner="Roger Preacher"
solutionname="Car"
productname="Toyota Corolla"
</Details_Collection>
</table>
</Report>
Code ends
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply