Browser: IE7
Database: SQL2005
When dealing with large XML files, 2000+ records the XLS transformation doesnot complete entirely.
My sample xml data looks something like this..
<DocumentElement>
<QueryResults>
<Date_Time>2008-01-15T00:00:00-05:00</Date_Time>
<Speed>42.13</Speed>
</QueryResults>
<QueryResults>
<Date_Time>2008-01-15T00:15:00-05:00</Date_Time>
<Speed>42.13</Speed>
</QueryResults>
</DocumentElement>
the xsl transformation does a number of things...
-Parse the date
-Make a bar graph and apply a color to the bar based on the speed
here is the xsl code....
----------------------------------------------------------
----------------------------------------------------------
<?xml version='1.0' encoding='utf-8'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:template match="/*">
<html>
<head>
<style>
td{font-size:10;font-family:arial;padding:0}
</style>
</head>
<body>
<table width="350px"><tr><td>
<table width="100%" height="100%">
<tr>
<td width="100px" align="right" style="padding-right:3"><br/></td>
<td>0</td>
<td align="right" style="padding-right:16">60</td>
<td><br/></td>
</tr>
</table>
</td></tr></table>
<table width="350px"><tr><td>
<xsl:for-each select="QueryResults">
<table width="100%" height="100%">
<tr>
<td width="100px" align="right" style="padding-right:3"><xsl:call-template name="FormatDate"><xsl:with-param name="DateTime" select="Date_Time"/></xsl:call-template></td>
<td colspan="2" width="250px">
<table style="border:solid;border-width:1;width:100%"><tr><td>
<table>
<xsl:attribute name="style">
<xsl:choose>
<xsl:when test="Speed < '50'">
<xsl:value-of select="concat('height:10;background-color:green',';width:',round(Speed * 100 div 60),'%')" />
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="concat('height:10;background-color:red',';width:',round(Speed * 100 div 60),'%')" />
</xsl:otherwise>
</xsl:choose>
</xsl:attribute>
<tr><td style='font-size:1'><br/></td></tr>
</table>
</td></tr></table>
</td>
<td width="1%" style="padding-left:3"><xsl:value-of select="Speed"/></td>
</tr>
</table>
</xsl:for-each></td>
</tr></table>
</body>
</html>
</xsl:template>
<xsl:template name="FormatDate">
<xsl:param name="DateTime" />
<!-- 1234567890123456789012345 -->
<!-- new date format 2008-01-14T00:00:00-05:00 -->
<xsl:variable name="year">
<xsl:value-of select="substring($DateTime,1,4)" />
</xsl:variable>
<xsl:variable name="mo">
<xsl:value-of select="substring($DateTime,6,2)" />
</xsl:variable>
<xsl:variable name="day">
<xsl:value-of select="substring($DateTime,9,2)" />
</xsl:variable>
<xsl:variable name="time-temp">
<xsl:value-of select="substring-after($DateTime,'T')" />
</xsl:variable>
<xsl:variable name="time">
<xsl:value-of select="substring-before($time-temp,'-')" />
</xsl:variable>
<xsl:variable name="hh">
<xsl:value-of select="substring($time,1,2)" />
</xsl:variable>
<xsl:variable name="mm">
<xsl:value-of select="substring($time,4,2)" />
</xsl:variable>
<xsl:variable name="ss">
<xsl:value-of select="substring($time,7,2)" />
</xsl:variable>
<xsl:choose>
<xsl:when test="$mo = '01'">Jan</xsl:when>
<xsl:when test="$mo = '02'">Feb</xsl:when>
<xsl:when test="$mo = '03'">Mar</xsl:when>
<xsl:when test="$mo = '04'">Apr</xsl:when>
<xsl:when test="$mo = '05'">May</xsl:when>
<xsl:when test="$mo = '06'">June</xsl:when>
<xsl:when test="$mo = '07'">July</xsl:when>
<xsl:when test="$mo = '08'">Aug</xsl:when>
<xsl:when test="$mo = '09'">Sept</xsl:when>
<xsl:when test="$mo = '10'">Oct</xsl:when>
<xsl:when test="$mo = '11'">Nov</xsl:when>
<xsl:when test="$mo = '12'">Dec</xsl:when>
</xsl:choose>
<xsl:value-of select="' '"/>
<xsl:if test="(string-length($day) < 2)">
<xsl:value-of select="0"/>
</xsl:if>
<xsl:value-of select="$day"/>
<xsl:value-of select="' '"/>
<xsl:value-of select="$year"/>
<xsl:value-of select="' '"/>
<xsl:value-of select="$hh"/>
<xsl:value-of select="':'"/>
<xsl:value-of select="$mm"/>
</xsl:template>
</xsl:stylesheet>
---------------------------------------------------------
---------------------------------------------------------
When I return the XML through the setting interface and cut and paste everything into my own XML file and XSL file and run that from my desktop top everything works as it should.
So I am confident that the code is not to blame, but i could be wrong.
Lastly when I refresh the page a couple times the results fail at different locations.
When I say "fail" i mean the data trails off. The data start to only display the data and no bar and ,eventually nothing.
So... this leaves me to think, is there a size limit? Is there a limit set somewhere in the web.config file, or in the module settings?
Any help or direction is much appreciated.
p.s. Sorry no public URL available, developed on an Inranet environment.
and the exact file return count is 2364 items.