SQLView Pro Reports

Edit Report

The following settings are common to all report types.

EditReport

General Options

Common Report Fields

Grid Report

Grid Report Settings

Grid Report Fields

Miscellaneous

XSL Report

Xsl Report Settings

XML/XSL Report Fields

XML Data

The data generated from your ‘Report Query’ will be transformed into valid XML and then passed through your xsl file which will result in the html output for your report.

For instance, if you were using the following query to grab data from the DNN tabs table,

SELECT TabId, TabName FROM {objectQualifier}Tabs

The way the XML is generated is as follows:

<SQLData>

<Table>
   <TabId>7</TabId>\
   <TabName>Host</TabName>\
</Table>
...

<Table>
   <TabId>17</TabId>\
   <TabName>Portals</TabName>\
</Table>
</SQLData>

A valid xsl file that could be used to transform this into html would look like the following:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="SQLData"> <b>Report</b>

<table cellpadding="1" cellspacing="1" border="1">
	<tr>
		<th>Tab Id</th>
		<th>Tab Name</th>
	</tr>
	<xsl:for-each select="Table">
	<tr>
		<td><xsl:value-of select="TabId"/></td>
		<td><xsl:value-of select="TabName"/></td>
	</tr>
	</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>

Template Report

A template report is a simplified version of the XML/XSL report type. For many, this is a much more accessible report type because the syntax is easier to understand and you can generate a very function report with this in a relatively short period of time without having to learn xsl.

Template Report Fields

Template Data

The data generated from your ‘Report Query’ will be passed into the template which will result in the html output for your report.

For instance, if you were using the following query to grab data from the DNN tabs table,

SELECT TabId, TabName FROM {objectQualifier}Tabs

A valid template that could be used to transform this into html would look like the following:

<table cellpadding="1" cellspacing="1" border="1">
	<tr>
		<th>Tab Id</th>
		<th>Tab Name</th>
	</tr>
	[EACHROW]
	<tr>
		<td>[TabId]</td>
		<td>[TabName]</td>
	</tr>
	[/EACHROW]
</table>