<?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();