<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/TR/WD-xsl">
  <xsl:template match="/">
    <HTML>
      <HEAD>
        <SCRIPT LANGUAGE="JSCRIPT"><xsl:comment><![CDATA[

          function hiLite()
          {
            e = window.event.srcElement;
            if (e.style.backgroundColor != 'yellow')
              e.style.backgroundColor = 'yellow';
            else
              e.style.backgroundColor = 'white';
          }

 		 function toggle(e) {
 		   if (e.style.display == "none") {
 		      e.style.display = "";
 		   } else {
 		      e.style.display = "none";
 		   }
 		 }

        ]]></xsl:comment></SCRIPT>
      </HEAD>
      <BODY>

<!-- Header Logo banner -->
<table border="0"  cellspacing="0" width="100%">
  <tr>
    <td width="14%" bgcolor="#963DD3"><img border="0" src="ww.gif" width="118" height="66"></img></td>
    <td width="86%" bgcolor="#963DD3">
      <p align="center"><b><font color="#FFFFFF" face="Arial" size="6">InSQL Runtime Database</font></b></p>
    </td>
  </tr>
</table>
<p align="center">  </p>

<DIV style="cursor: hand" 
onmouseover="this.style.color='red'"
onmouseout="this.style.color=''">

</DIV>
<blockquote>
	<SPAN id="ReportHeaderSpan" style = "display: ">

    <TABLE BORDER="0" width="100%">
	<xsl:for-each select="DATABASEREPORT/REPORTHEADER">
        <TR>
		<TD width="20%" ALIGN="right"> <B>Server: </B></TD>
       	<TD><B><xsl:value-of select="SERVERNAME"/></B></TD>
		<TD ALIGN="right"><B>Date: </B></TD>
       	<TD><xsl:value-of select="REPORTDATE"/></TD>
       	</TR>
       	</xsl:for-each>
       	</TABLE>
	</SPAN>
</blockquote>

<!-- Line -->
<hr> 
</hr>

<p><i><b>Click on an item to expand or collapse</b></i></p>

<!-- System parameter information -->
<FONT STYLE="Arial" COLOR="blue">

<DIV style="cursor: hand" 
onclick="toggle(document.all.SystemParametersReportSpan)" 
onmouseover="this.style.color='red'"
onmouseout="this.style.color=''">

<li><P><h3>System Parameters</h3></P></li>
</DIV>
<blockquote>
	<SPAN id="SystemParametersReportSpan" style = "display: none">

        <TABLE BORDER="0" width="100%">
	<!-- Do not display the column headers
	<TR>
	<TD><B>Parameter Name</B></TD>
	<TD><B>Value</B></TD>
	</TR>
	-->
	<xsl:for-each select="DATABASEREPORT/SYSTEMPARAMETERSREPORT/ROW">
        <TR>
       	<TD><B><xsl:value-of select="PARAMETER"/></B></TD>
       	<TD><xsl:value-of select="VALUE"/></TD>
       	</TR>
       	</xsl:for-each>
       	</TABLE>
	</SPAN>
</blockquote>

<!-- Line -->
<hr> 
</hr>


<!-- TAG COUNT --> 
<DIV style="cursor: hand" 
onclick="toggle(document.all.LicensedTagDetailReportSpan)" 
onmouseover="this.style.color='red'"
onmouseout="this.style.color=''">

<li><P><h3>Tag Counts</h3></P></li>
</DIV>
<blockquote>
	<SPAN id="LicensedTagDetailReportSpan" style = "display: none">
	<TABLE BORDER="0" width="100%">
        <TR>
        <TD><B>Tag Type</B></TD>
        <TD><B>Tag Count</B></TD>
        <TD><B>Licensed Tags</B></TD>
        </TR>

        <xsl:for-each select="DATABASEREPORT/LICENSEDTAGDETAILREPORT/ROW">
        <TR>
        <TD><xsl:value-of select="CATEGORY"/></TD>
        <TD><xsl:value-of select="TAGCOUNT"/></TD>
        <TD><xsl:value-of select="LICENSEDTAGCOUNT"/></TD>
        </TR>
        </xsl:for-each>
        </TABLE>
	<p><i><b>Note: System tags and Event tags are excluded from the Licensed tag count.</b></i></p>
	</SPAN>
</blockquote>

<!-- ANA TAG STORAGE -->
<blockquote>
	<DIV style="cursor: hand" 
	onclick="toggle(document.all.AnalogTagStorageDetailReportSpan)" 
	onmouseover="this.style.color='red'"
    onmouseout="this.style.color=''">
	<li><P><h4>Analog Tag Storage Detail</h4></P></li>
	</DIV>
	<blockquote>
		<SPAN id="AnalogTagStorageDetailReportSpan" style = "display: none">
       		<TABLE BORDER="0" width="100%">
       		<TR>
       		<TD><B>Storage Type</B></TD>
       		<TD><B>Tag Count</B></TD>
      		</TR>
       		<xsl:for-each select="DATABASEREPORT/ANALOGTAGSTORAGEDETAILREPORT/ROW">
       		<TR>
       		<TD><xsl:value-of select="CATEGORY"/></TD>
       		<TD><xsl:value-of select="COUNT"/></TD>
       		</TR>
      		</xsl:for-each>
       		</TABLE>
		</SPAN>
	</blockquote>
</blockquote>


<!-- CYCLIC STORAGE  -->
<blockquote>
	<DIV style="cursor: hand" 
	onclick="toggle(document.all.CyclicStorageDetailReportSpan)" 
	onmouseover="this.style.color='red'"
	onmouseout="this.style.color=''">
	<li><P><h4>Cyclic Storage Detail</h4></P></li>
	</DIV>
	<blockquote>
		<SPAN id="CyclicStorageDetailReportSpan" style = "display: none">
        	<TABLE BORDER="0" width="100%">
		<TR>
		<TD><B>Storage Rate (in sec)</B></TD>
		<TD><B>Tag Count</B></TD>
          	</TR>
          	<xsl:for-each select="DATABASEREPORT/CYCLICSTORAGEDETAILREPORT/ROW">
            	<TR>
		<TD><xsl:value-of select="STORAGERATE"/></TD>
		<TD><xsl:value-of select="COUNT"/></TD>
		</TR>
		</xsl:for-each>
		</TABLE>
		</SPAN>
	</blockquote>
</blockquote>

<!-- Line -->
<hr> 
</hr>


<!-- DATA ACQUISTION -->

<DIV style="cursor: hand" 
onclick="toggle(document.all.DataAcquisitionDetailReportSpan)" 
onmouseover="this.style.color='red'"
onmouseout="this.style.color=''">

<li><P><h3>Data Acquisition Detail</h3></P></li>
</DIV>
<blockquote>
	<SPAN id="DataAcquisitionDetailReportSpan" style = "display: none">
        <TABLE BORDER="0" width="100%">
	<TR>
	<TD><B>IDAS Location</B></TD>
	<TD><B>IO Server Location</B></TD>
	<TD><B>Application Name</B></TD>
	<TD><B>Topic</B></TD>
	<TD><B>Protocol</B></TD>
	</TR>
	<xsl:for-each select="DATABASEREPORT/DATAACQUISITIONDETAILREPORT/ROW">
	<TR>
	<TD><xsl:value-of select="IODRIVERLOCATION"/></TD>
	<TD><xsl:value-of select="IOSERVERLOCATION"/></TD>
	<TD><xsl:value-of select="APPLICATIONNAME"/></TD>
	<TD><xsl:value-of select="TOPICNAME"/></TD>
	<TD><xsl:value-of select="PROTOCOL"/></TD>
	</TR>
	</xsl:for-each>
	</TABLE>
	</SPAN>
</blockquote>

<!-- Line -->
<hr> 
</hr>

<!-- Event Tags -->

<DIV style="cursor: hand"
onclick="toggle(document.all.EventTagDetailReportSpan)" 
onmouseover="this.style.color='red'"
onmouseout="this.style.color=''">

<li><P><h3>Event Tag Detail</h3></P></li>
</DIV>
<blockquote>
	<SPAN id="EventTagDetailReportSpan" style = "display: none">
	<TABLE BORDER="0" width="100%">
	<TR>
	<TD><B>Tag Name</B></TD>
	<TD><B>Detector Type</B></TD>
	<TD><B>Action Type</B></TD>
	<TD><B>Postdetector Delay</B></TD>
	</TR>
	<xsl:for-each select="DATABASEREPORT/EVENTTAGDETAILREPORT/ROW">
	<TR>
	<TD><xsl:value-of select="TAGNAME"/></TD>
	<TD><xsl:value-of select="DETECTORTYPENAME"/></TD>
	<TD><xsl:value-of select="ACTIONTYPENAME"/></TD>
	<TD><xsl:value-of select="POSTDETECTORDELAY"/></TD>
	</TR>
	</xsl:for-each>
	</TABLE>
	</SPAN>
</blockquote>

<!-- Schedule Event tag -->
<blockquote>
	<DIV style="cursor: hand" 
	onclick="toggle(document.all.ScheduleEventTagDetailReportSpan)" 
	onmouseover="this.style.color='red'"
	onmouseout="this.style.color=''">

	<li><P><h4>Schedule Event Tag Detail</h4></P></li>
	</DIV>
	<blockquote>
		<SPAN id="ScheduleEventTagDetailReportSpan" style = "display: none">
		<TABLE BORDER="0" width="100%">
		<TR>
		<TD><B>Tag Name</B></TD>
		<TD><B>Frequency</B></TD>
		<TD><B>Day</B></TD>
		<TD><B>Hour</B></TD>
		<TD><B>Minute</B></TD>
		<TD><B>Periodicity</B></TD>
		<TD><B>Start Date/Time</B></TD>
		</TR>
		<xsl:for-each select="DATABASEREPORT/SCHEDULEEVENTTAGDETAILREPORT/ROW">
		<TR>
		<TD><xsl:value-of select="TAGNAME"/></TD>
		<TD><xsl:value-of select="FREQUENCYID"/></TD>
		<TD><xsl:value-of select="RUNTIMEDAY"/></TD>
		<TD><xsl:value-of select="RUNTIMEHOUR"/></TD>
		<TD><xsl:value-of select="RUNTIMEMINUTE"/></TD>
		<TD><xsl:value-of select="PERIODICITY"/></TD>
		<TD><xsl:value-of select="STARTDATETIME"/></TD>
		</TR>
		</xsl:for-each>
		</TABLE>
		</SPAN>
	</blockquote>
</blockquote>

<!-- Line -->
<hr> 
</hr>


<!-- Summary Information  -->

<DIV style="cursor: hand" 
     onclick="toggle(document.all.SummaryOperationsReportSpan)" 
     onmouseover="this.style.color='red'"
	 onmouseout="this.style.color=''">

<li><P><h3>Summary Operations</h3></P></li>
</DIV>

<blockquote>
	<SPAN id="SummaryOperationsReportSpan" style = "display: none">
	<TABLE BORDER="0" width="100%">
	<TR>
	<TD><B>Tag Name</B></TD>
	<TD><B>Calculation Type</B></TD>
	<TD><B>Duration</B></TD>
	<TD><B>Resolution</B></TD>
	<TD><B>Timestamp</B></TD>
	</TR>
	<xsl:for-each select="DATABASEREPORT/SUMMARYOPERATIONREPORT/ROW">
	<TR>
	<TD><xsl:value-of select="TAGNAME"/></TD>
	<TD><xsl:value-of select="CALCTYPE"/></TD>
	<TD><xsl:value-of select="DURATION"/></TD>
	<TD><xsl:value-of select="RESOLUTION"/></TD>
	<TD><xsl:value-of select="TIMESTAMP"/></TD>
	</TR>
	</xsl:for-each>
	</TABLE>
	</SPAN>
</blockquote>

<!-- Tag List per Summary Calculation -->

<blockquote>
	<DIV style="cursor: hand" 
	     onclick="toggle(document.all.SummaryTagListBySummaryTypeReportSpan)" 
	     onmouseover="this.style.color='red'"
		 onmouseout="this.style.color=''">

	<li><P><h4>Summary Tag List By Summary Type</h4></P></li>
	</DIV>

	<blockquote>
		<SPAN id="SummaryTagListBySummaryTypeReportSpan" style = "display: none">
		<TABLE BORDER="0" width="100%">
		<TR>
		<TD><B>Event Tag Name</B></TD>
		<TD><B>Calculation Type</B></TD>
		<TD><B>Tag Name Calculations</B></TD>
		</TR>
		<xsl:for-each select="DATABASEREPORT/SUMMARYTAGLISTBYSUMMARYTYPEREPORT/ROW">
		<TR>
		<TD><xsl:value-of select="SUMMARYOPERATIONTAGNAME"/></TD>
		<TD><xsl:value-of select="CALCTYPE"/></TD>
		<TD><xsl:value-of select="SUMMARYTAGLISTTAGNAME"/></TD>
		</TR>
		</xsl:for-each>
		</TABLE>
		</SPAN>
	</blockquote>
</blockquote>


<!-- Tag List per Calculated Tag -->

<blockquote>
	<DIV style="cursor: hand" 
	onclick="toggle(document.all.SummaryTagListByCalculatedTagtReportSpan)" 
	     onmouseover="this.style.color='red'"
		 onmouseout="this.style.color=''">

	<li><P><h4>Summary Tag List By Calculated Tag</h4></P></li>
	</DIV>

	<blockquote>
		<SPAN id="SummaryTagListByCalculatedTagtReportSpan" style = "display: none">
		<TABLE BORDER="0" width="100%">
		<TR>
		<TD><B>Tag Name</B></TD>
		<TD><B>Calculation Type</B></TD>
		<TD><B>Event Tag Name</B></TD>
		</TR>
		<xsl:for-each select="DATABASEREPORT/SUMMARYTAGLISTBYCALCULATEDTAGREPORT/ROW">
		<TR>
		<TD><xsl:value-of select="SUMMARYTAGLISTTAGNAME"/></TD>
		<TD><xsl:value-of select="CALCTYPE"/></TD>
		<TD><xsl:value-of select="SUMMARYOPERATIONTAGNAME"/></TD>
		</TR>
		</xsl:for-each>
		</TABLE>
		</SPAN>
	</blockquote>
</blockquote>

<!-- Line -->
<hr> 
</hr>

</FONT>
</BODY>
</HTML>
</xsl:template>
</xsl:stylesheet>