Matrix Report using SQL Server XML and XSLT Code

Desiging Matrix Report using SQL Server XML, XSLT and JAVA Code

In the above matrix report image is grouped week by employee vs employee by week.
Part 1 - SQL CODE

DECLARE @depart_id int
DECLARE @startdate datetime
DECLARE @enddate DATETIME

SET @depart_id = 314
SET @startdate = '01/01/2001'
SET @enddate = '02/28/2001'

DECLARE @e_id int
DECLARE @ename varchar(100)

Creating temporary table

ASP.NET Custom Errors(customErrors) and URL Mappings (urlMappings)

URL Mappings

1. Open web.config file. (see MSDN)
2. Create new urlMappings section within the system.web section.
3. <urlMappings enabled="true">
   <add url="~/contactus.aspx" mappedUrl="~/index.aspx" />
   </urlMappings>
   
4. If user types contactus.aspx, page mapped to the index.aspx.
5. This approach won't work if you have 100 of pages to map.
6. Best solution is to use regular expressions, but ASP.NET does not support. SEE
   URL Rewriting

XSLT Pagination and For Loop Code

For Loop 1 - 10

<xsl:call-template name="forloop">
  <xsl:with-param name="i"><xsl:value-of select="count(ts/@weekenddate)+1"/></xsl:with-param>
  <xsl:with-param name="count"><xsl:value-of select="$totalweekend"/></xsl:with-param>
</xsl:call-template>

<xsl:template name="forloop">
  <xsl:param name="i" />
  <xsl:param name="count" />
  <xsl:if test="$i <= $count"><TD align="center"> </TD></xsl:if>

  <xsl:if test="$i <= $count">
    <xsl:call-template name="for.loop">
      <xsl:with-param name="i">
        <xsl:value-of select="$i + 1"/>
      </xsl:with-param>
      <xsl:with-param name="count">
        <xsl:value-of select="$count"/>
      </xsl:with-param>
    </xsl:call-template>
  </xsl:if>
</xsl:template>

Pagination