<!--webbot bot="DatabaseRegionStart" s-columnnames="Scans" s-columntypes="5" s-dataconnection="BureauManagerSQL" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="Scans" s-menuvalue="Scans" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="FALSE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns="Scans" s-criteria s-order s-sql="SELECT     SUM(dbo.WorkDetails.Quantity) AS Scans<br>FROM         dbo.WorkDetails INNER JOIN<br>                      dbo.WorkType ON dbo.WorkDetails.WorkType = dbo.WorkType.WorkType<br>WHERE     (dbo.WorkType.JobType_ID = 'S')<br>GROUP BY dbo.WorkDetails.SiteID, { fn DAYOFYEAR(dbo.WorkDetails.WorkDate) }, YEAR(dbo.WorkDetails.WorkDate)<br>HAVING      (YEAR(dbo.WorkDetails.WorkDate) = YEAR({ fn NOW() })) AND (dbo.WorkDetails.SiteID = '5') AND ({ fn DAYOFYEAR(dbo.WorkDetails.WorkDate) <br>                      } = { fn DAYOFYEAR({ fn NOW() }) })" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="5" u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" startspan --><!--#include file="../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT     SUM(dbo.WorkDetails.Quantity) AS Scans FROM         dbo.WorkDetails INNER JOIN                       dbo.WorkType ON dbo.WorkDetails.WorkType = dbo.WorkType.WorkType WHERE     (dbo.WorkType.JobType_ID = 'S') GROUP BY dbo.WorkDetails.SiteID, { fn DAYOFYEAR(dbo.WorkDetails.WorkDate) }, YEAR(dbo.WorkDetails.WorkDate) HAVING      (YEAR(dbo.WorkDetails.WorkDate) = YEAR({ fn NOW() })) AND (dbo.WorkDetails.SiteID = '5') AND ({ fn DAYOFYEAR(dbo.WorkDetails.WorkDate)                        } = { fn DAYOFYEAR({ fn NOW() }) })"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=1 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="BureauManagerSQL"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Scans"
fp_sMenuValue="Scans"
fp_sColTypes="&Scans=5&"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=5
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="4786" -->