<?php
}
?>
</tr></table>
<?php
}
?>
</td>
</tr>
</thead>
<tbody>
<?php
$Report13_summary->ShowFirstHeader = FALSE;
}
// Build detail SQL
$sWhere = ewrpt_DetailFilterSQL($Report13->First_Name, $Report13->SqlFirstGroupField(), $Report13->First_Name->GroupValue());
if ($Report13_summary->Filter != "") {
$sWhere = "({$Report13_summary->Filter}) AND ({$sWhere})";
}
$sSql = ewrpt_BuildReportSql($Report13->SqlSelect(), $Report13->SqlWhere(), $Report13->SqlGroupBy(), $Report13->SqlHaving(), $Report13->SqlOrderBy(), $sWhere, $Report13_summary->Sort);
$rs = $conn->Execute($sSql);
$rsdtlcnt = $rs ? $rs->RecordCount() : 0;
if ($rsdtlcnt > 0) {
$Report13_summary->GetRow(1);
}
while ($rs && !$rs->EOF) {
// Loop detail records
$Report13_summary->RecCount++;
// Render detail row
$Report13->ResetCSS();
$Report13->RowType = EWRPT_ROWTYPE_DETAIL;
$Crosstab1_crosstab->StopGrp = $Crosstab1_crosstab->StartGrp + $Crosstab1_crosstab->DisplayGrps - 1;
}
// Stop group <= total number of groups
if (intval($Crosstab1_crosstab->StopGrp) > intval($Crosstab1_crosstab->TotalGrps)) {
$Crosstab1_crosstab->StopGrp = $Crosstab1_crosstab->TotalGrps;
}
// Navigate
$Crosstab1_crosstab->RecCount = 0;
// Get first row
if ($Crosstab1_crosstab->TotalGrps > 0) {
$Crosstab1_crosstab->GetGrpRow(1);
$Crosstab1_crosstab->GrpCount = 1;
}
while ($rsgrp && !$rsgrp->EOF && $Crosstab1_crosstab->GrpCount <= $Crosstab1_crosstab->DisplayGrps) {
// Build detail SQL
$sWhere = ewrpt_DetailFilterSQL($Crosstab1->First_Name, $Crosstab1->SqlFirstGroupField(), $Crosstab1->First_Name->GroupValue());
if ($Crosstab1_crosstab->Filter != "") {
$sWhere = "({$Crosstab1_crosstab->Filter}) AND ({$sWhere})";
}
$sSql = ewrpt_BuildReportSql($Crosstab1_crosstab->SqlSelectWork, $Crosstab1->SqlWhere(), $Crosstab1->SqlGroupBy(), "", $Crosstab1->SqlOrderBy(), $sWhere, $Crosstab1_crosstab->Sort);
$rs = $conn->Execute($sSql);
$rsdtlcnt = $rs ? $rs->RecordCount() : 0;
if ($rsdtlcnt > 0) {
$Crosstab1_crosstab->GetRow(1);
}
while ($rs && !$rs->EOF) {
$Crosstab1_crosstab->RecCount++;
// Render row
$Crosstab1->ResetCSS();
$Crosstab1->RowType = EWRPT_ROWTYPE_DETAIL;
$Crosstab1_crosstab->RenderRow();