} } ?> <!-- Dynamic columns end --> </tr> </thead> <tbody> <?php if ($Page->TotalGrps == 0) { break; } // Show header only $Page->ShowHeader = FALSE; } // Build detail SQL $sWhere = ewr_DetailFilterSQL($Page->invid, $Page->getSqlFirstGroupField(), $Page->invid->GroupValue()); if ($Page->PageFirstGroupFilter != "") { $Page->PageFirstGroupFilter .= " OR "; } $Page->PageFirstGroupFilter .= $sWhere; if ($Page->Filter != "") { $sWhere = "({$Page->Filter}) AND ({$sWhere})"; } $sSql = ewr_BuildReportSql(str_replace("<DistinctColumnFields>", $Page->DistinctColumnFields, $Page->getSqlSelect()), $Page->getSqlWhere(), $Page->getSqlGroupBy(), "", $Page->getSqlOrderBy(), $sWhere, $Page->Sort); $rs = $conn->Execute($sSql); $rsdtlcnt = $rs ? $rs->RecordCount() : 0; if ($rsdtlcnt > 0) { $Page->GetRow(1); } while ($rs && !$rs->EOF) { $Page->RecCount++;
><?php echo $ReportLanguage->Phrase("Total"); ?> </div></td> </tr> </thead> <tbody> <?php if ($Page->TotalGrps == 0) { break; } // Show header only $Page->ShowHeader = FALSE; } // Build detail SQL $sWhere = ewr_DetailFilterSQL($Page->University, $Page->getSqlFirstGroupField(), $Page->University->GroupValue()); if ($Page->PageFirstGroupFilter != "") { $Page->PageFirstGroupFilter .= " OR "; } $Page->PageFirstGroupFilter .= $sWhere; if ($Page->Filter != "") { $sWhere = "({$Page->Filter}) AND ({$sWhere})"; } $sSql = ewr_BuildReportSql(str_replace("<DistinctColumnFields>", $Page->DistinctColumnFields, $Page->getSqlSelect()), $Page->getSqlWhere(), $Page->getSqlGroupBy(), "", $Page->getSqlOrderBy(), $sWhere, $Page->Sort); $rs = $conn->Execute($sSql); $rsdtlcnt = $rs ? $rs->RecordCount() : 0; if ($rsdtlcnt > 0) { $Page->GetRow(1); } while ($rs && !$rs->EOF) { $Page->RecCount++;
><?php echo $ReportLanguage->Phrase("Total"); ?> </div></td> </tr> </thead> <tbody> <?php if ($Page->TotalGrps == 0) { break; } // Show header only $Page->ShowHeader = FALSE; } // Build detail SQL $sWhere = ewr_DetailFilterSQL($Page->Job_Name, $Page->getSqlFirstGroupField(), $Page->Job_Name->GroupValue()); if ($Page->PageFirstGroupFilter != "") { $Page->PageFirstGroupFilter .= " OR "; } $Page->PageFirstGroupFilter .= $sWhere; if ($Page->Filter != "") { $sWhere = "({$Page->Filter}) AND ({$sWhere})"; } $sSql = ewr_BuildReportSql(str_replace("<DistinctColumnFields>", $Page->DistinctColumnFields, $Page->getSqlSelect()), $Page->getSqlWhere(), $Page->getSqlGroupBy(), "", $Page->getSqlOrderBy(), $sWhere, $Page->Sort); $rs = $conn->Execute($sSql); $rsdtlcnt = $rs ? $rs->RecordCount() : 0; if ($rsdtlcnt > 0) { $Page->GetRow(1); } while ($rs && !$rs->EOF) { $Page->RecCount++;