SQLView Pro comes standard with 3 different report types, Grid, XSL and Template. The following example shows an XSL report of a single employee record. XSL stands for Extensible Stylesheet Language and is a stylesheet language for XML documents. XSLT stands for XSL Transformations and can be used to transform XML data into standard HTML to be rendered to the browser.
In this example I'm pulling out a single employee record and using an xsl file to transform it into a simple vertical table.
The xsl to accomplish this looks like this:
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="SQLData">
<table cellpadding="2" cellspacing="0" border="1" width="500px">
<xsl:for-each select="Table">
<tr>
<td style="background-color: #d0d0d0">
First Name
</td><td style="background-color: #ffffff">
<xsl:value-of select="FirstName"/>
</td>
</tr>
<tr>
<td style="background-color: #d0d0d0">
Last Name
</td><td style="background-color: #ffffff">
<xsl:value-of select="LastName"/>
</td>
</tr>
<tr>
<td style="background-color: #d0d0d0">
Hire Date
</td><td style="background-color: #ffffff">
<xsl:value-of select="HireDate"/>
</td>
</tr>
<tr>
<td style="background-color: #d0d0d0">
Address
</td><td style="background-color: #ffffff">
<xsl:value-of select="Address"/>
</td>
</tr>
<tr>
<td style="background-color: #d0d0d0">
State
</td><td style="background-color: #ffffff">
<xsl:value-of select="State"/>
</td>
</tr>
<tr>
<td style="background-color: #d0d0d0">
Zip
</td><td style="background-color: #ffffff">
<xsl:value-of select="Zip"/>
</td>
</tr>
<tr>
<td style="background-color: #d0d0d0">
Country
</td><td style="background-color: #ffffff">
<xsl:value-of select="Country"/>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>
The complete file is also located here Employee.xsl.