function RenderRow()
 {
     global $conn, $Security;
     global $CustomView2;
     if ($CustomView2->RowTotalType == EWRPT_ROWTOTAL_GRAND) {
         // Grand total
         // Get total count from sql directly
         $sSql = ewrpt_BuildReportSql($CustomView2->SqlSelectCount(), $CustomView2->SqlWhere(), $CustomView2->SqlGroupBy(), $CustomView2->SqlHaving(), "", $this->Filter, "");
         $rstot = $conn->Execute($sSql);
         if ($rstot) {
             $this->TotCount = $rstot->RecordCount() > 1 ? $rstot->RecordCount() : $rstot->fields[0];
             $rstot->Close();
         } else {
             $this->TotCount = 0;
         }
     }
     // Call Row_Rendering event
     $CustomView2->Row_Rendering();
     /* --------------------
     		'  Render view codes
     		' --------------------- */
     if ($CustomView2->RowType == EWRPT_ROWTYPE_TOTAL) {
         // Summary row
         // Total
         $CustomView2->Total->ViewValue = $CustomView2->Total->Summary;
     } else {
         // Total
         $CustomView2->Total->ViewValue = $CustomView2->Total->CurrentValue;
         $CustomView2->Total->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
     }
     // Total
     $CustomView2->Total->HrefValue = "";
     // Call Row_Rendered event
     $CustomView2->Row_Rendered();
 }
Esempio n. 2
0
 function RenderRow()
 {
     global $conn, $Security;
     global $Report3;
     if ($Report3->RowTotalType == EWRPT_ROWTOTAL_GRAND) {
         // Grand total
         // Get total count from sql directly
         $sSql = ewrpt_BuildReportSql($Report3->SqlSelectCount(), $Report3->SqlWhere(), $Report3->SqlGroupBy(), $Report3->SqlHaving(), "", $this->Filter, "");
         $rstot = $conn->Execute($sSql);
         if ($rstot) {
             $this->TotCount = $rstot->RecordCount() > 1 ? $rstot->RecordCount() : $rstot->fields[0];
             $rstot->Close();
         } else {
             $this->TotCount = 0;
         }
     }
     // Call Row_Rendering event
     $Report3->Row_Rendering();
     /* --------------------
     		'  Render view codes
     		' --------------------- */
     if ($Report3->RowType == EWRPT_ROWTYPE_TOTAL) {
         // Summary row
         // (Select Count(*)* 100 / (Select Count(*) From students) as Score From class_std group by paper_id)
         $Report3->z28Select_Count282A292A_100_2F_28Select_Count282A29_From_students29_as_Score_From_class_std_group_by_paper_id29->ViewValue = $Report3->z28Select_Count282A292A_100_2F_28Select_Count282A29_From_students29_as_Score_From_class_std_group_by_paper_id29->Summary;
     } else {
         // (Select Count(*)* 100 / (Select Count(*) From students) as Score From class_std group by paper_id)
         $Report3->z28Select_Count282A292A_100_2F_28Select_Count282A29_From_students29_as_Score_From_class_std_group_by_paper_id29->ViewValue = $Report3->z28Select_Count282A292A_100_2F_28Select_Count282A29_From_students29_as_Score_From_class_std_group_by_paper_id29->CurrentValue;
         $Report3->z28Select_Count282A292A_100_2F_28Select_Count282A29_From_students29_as_Score_From_class_std_group_by_paper_id29->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
     }
     // (Select Count(*)* 100 / (Select Count(*) From students) as Score From class_std group by paper_id)
     $Report3->z28Select_Count282A292A_100_2F_28Select_Count282A29_From_students29_as_Score_From_class_std_group_by_paper_id29->HrefValue = "";
     // Call Row_Rendered event
     $Report3->Row_Rendered();
 }
Esempio n. 3
0
 function RenderRow()
 {
     global $conn, $Security;
     global $users;
     if ($users->RowTotalType == EWRPT_ROWTOTAL_GRAND) {
         // Grand total
         // Get total count from sql directly
         $sSql = ewrpt_BuildReportSql($users->SqlSelectCount(), $users->SqlWhere(), $users->SqlGroupBy(), $users->SqlHaving(), "", $this->Filter, "");
         $rstot = $conn->Execute($sSql);
         if ($rstot) {
             $this->TotCount = $rstot->RecordCount() > 1 ? $rstot->RecordCount() : $rstot->fields[0];
             $rstot->Close();
         } else {
             $this->TotCount = 0;
         }
     }
     // Call Row_Rendering event
     $users->Row_Rendering();
     /* --------------------
     		'  Render view codes
     		' --------------------- */
     if ($users->RowType == EWRPT_ROWTYPE_TOTAL) {
         // Summary row
         // users_id
         $users->users_id->ViewValue = $users->users_id->Summary;
         // user_firstname
         $users->user_firstname->ViewValue = $users->user_firstname->Summary;
         // user_lastname
         $users->user_lastname->ViewValue = $users->user_lastname->Summary;
         // email_id
         $users->email_id->ViewValue = $users->email_id->Summary;
         // phone_no
         $users->phone_no->ViewValue = $users->phone_no->Summary;
         // branch
         $users->branch->ViewValue = $users->branch->Summary;
         // username
         $users->username->ViewValue = $users->username->Summary;
         // password
         $users->password->ViewValue = $users->password->Summary;
         // user_created
         $users->user_created->ViewValue = $users->user_created->Summary;
     } else {
         // users_id
         $users->users_id->ViewValue = $users->users_id->CurrentValue;
         $users->users_id->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // user_firstname
         $users->user_firstname->ViewValue = $users->user_firstname->CurrentValue;
         $users->user_firstname->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // user_lastname
         $users->user_lastname->ViewValue = $users->user_lastname->CurrentValue;
         $users->user_lastname->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // email_id
         $users->email_id->ViewValue = $users->email_id->CurrentValue;
         $users->email_id->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // phone_no
         $users->phone_no->ViewValue = $users->phone_no->CurrentValue;
         $users->phone_no->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // branch
         $users->branch->ViewValue = $users->branch->CurrentValue;
         $users->branch->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // username
         $users->username->ViewValue = $users->username->CurrentValue;
         $users->username->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // password
         $users->password->ViewValue = $users->password->CurrentValue;
         $users->password->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // user_created
         $users->user_created->ViewValue = $users->user_created->CurrentValue;
         $users->user_created->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
     }
     // users_id
     $users->users_id->HrefValue = "";
     // user_firstname
     $users->user_firstname->HrefValue = "";
     // user_lastname
     $users->user_lastname->HrefValue = "";
     // email_id
     $users->email_id->HrefValue = "";
     // phone_no
     $users->phone_no->HrefValue = "";
     // branch
     $users->branch->HrefValue = "";
     // username
     $users->username->HrefValue = "";
     // password
     $users->password->HrefValue = "";
     // user_created
     $users->user_created->HrefValue = "";
     // Call Row_Rendered event
     $users->Row_Rendered();
 }
 function RenderRow()
 {
     global $conn, $Security;
     global $Report13;
     if ($Report13->RowTotalType == EWRPT_ROWTOTAL_GRAND) {
         // Grand total
         // Get total count from sql directly
         $sSql = ewrpt_BuildReportSql($Report13->SqlSelectCount(), $Report13->SqlWhere(), $Report13->SqlGroupBy(), $Report13->SqlHaving(), "", $this->Filter, "");
         $rstot = $conn->Execute($sSql);
         if ($rstot) {
             $this->TotCount = $rstot->RecordCount() > 1 ? $rstot->RecordCount() : $rstot->fields[0];
             $rstot->Close();
         } else {
             $this->TotCount = 0;
         }
     }
     // Call Row_Rendering event
     $Report13->Row_Rendering();
     /* --------------------
     		'  Render view codes
     		' --------------------- */
     if ($Report13->RowType == EWRPT_ROWTYPE_TOTAL) {
         // Summary row
         // First Name
         $Report13->First_Name->GroupViewValue = $Report13->First_Name->GroupOldValue();
         $Report13->First_Name->CellAttrs["class"] = $Report13->RowGroupLevel == 1 ? "ewRptGrpSummary1" : "ewRptGrpField1";
         $Report13->First_Name->GroupViewValue = ewrpt_DisplayGroupValue($Report13->First_Name, $Report13->First_Name->GroupViewValue);
         // Last Name
         $Report13->Last_Name->GroupViewValue = $Report13->Last_Name->GroupOldValue();
         $Report13->Last_Name->CellAttrs["class"] = $Report13->RowGroupLevel == 2 ? "ewRptGrpSummary2" : "ewRptGrpField2";
         $Report13->Last_Name->GroupViewValue = ewrpt_DisplayGroupValue($Report13->Last_Name, $Report13->Last_Name->GroupViewValue);
         // Paper Name
         $Report13->Paper_Name->GroupViewValue = $Report13->Paper_Name->GroupOldValue();
         $Report13->Paper_Name->CellAttrs["class"] = $Report13->RowGroupLevel == 3 ? "ewRptGrpSummary3" : "ewRptGrpField3";
         $Report13->Paper_Name->GroupViewValue = ewrpt_DisplayGroupValue($Report13->Paper_Name, $Report13->Paper_Name->GroupViewValue);
         // Total Marks
         $Report13->Total_Marks->GroupViewValue = $Report13->Total_Marks->GroupOldValue();
         $Report13->Total_Marks->CellAttrs["class"] = $Report13->RowGroupLevel == 4 ? "ewRptGrpSummary4" : "ewRptGrpField4";
         $Report13->Total_Marks->GroupViewValue = ewrpt_DisplayGroupValue($Report13->Total_Marks, $Report13->Total_Marks->GroupViewValue);
         // Total Time
         $Report13->Total_Time->GroupViewValue = $Report13->Total_Time->GroupOldValue();
         $Report13->Total_Time->CellAttrs["class"] = $Report13->RowGroupLevel == 5 ? "ewRptGrpSummary5" : "ewRptGrpField5";
         $Report13->Total_Time->GroupViewValue = ewrpt_DisplayGroupValue($Report13->Total_Time, $Report13->Total_Time->GroupViewValue);
     } else {
         // First Name
         $Report13->First_Name->GroupViewValue = $Report13->First_Name->GroupValue();
         $Report13->First_Name->CellAttrs["class"] = "ewRptGrpField1";
         $Report13->First_Name->GroupViewValue = ewrpt_DisplayGroupValue($Report13->First_Name, $Report13->First_Name->GroupViewValue);
         if ($Report13->First_Name->GroupValue() == $Report13->First_Name->GroupOldValue() && !$this->ChkLvlBreak(1)) {
             $Report13->First_Name->GroupViewValue = " ";
         }
         // Last Name
         $Report13->Last_Name->GroupViewValue = $Report13->Last_Name->GroupValue();
         $Report13->Last_Name->CellAttrs["class"] = "ewRptGrpField2";
         $Report13->Last_Name->GroupViewValue = ewrpt_DisplayGroupValue($Report13->Last_Name, $Report13->Last_Name->GroupViewValue);
         if ($Report13->Last_Name->GroupValue() == $Report13->Last_Name->GroupOldValue() && !$this->ChkLvlBreak(2)) {
             $Report13->Last_Name->GroupViewValue = " ";
         }
         // Paper Name
         $Report13->Paper_Name->GroupViewValue = $Report13->Paper_Name->GroupValue();
         $Report13->Paper_Name->CellAttrs["class"] = "ewRptGrpField3";
         $Report13->Paper_Name->GroupViewValue = ewrpt_DisplayGroupValue($Report13->Paper_Name, $Report13->Paper_Name->GroupViewValue);
         if ($Report13->Paper_Name->GroupValue() == $Report13->Paper_Name->GroupOldValue() && !$this->ChkLvlBreak(3)) {
             $Report13->Paper_Name->GroupViewValue = " ";
         }
         // Total Marks
         $Report13->Total_Marks->GroupViewValue = $Report13->Total_Marks->GroupValue();
         $Report13->Total_Marks->CellAttrs["class"] = "ewRptGrpField4";
         $Report13->Total_Marks->GroupViewValue = ewrpt_DisplayGroupValue($Report13->Total_Marks, $Report13->Total_Marks->GroupViewValue);
         if ($Report13->Total_Marks->GroupValue() == $Report13->Total_Marks->GroupOldValue() && !$this->ChkLvlBreak(4)) {
             $Report13->Total_Marks->GroupViewValue = " ";
         }
         // Total Time
         $Report13->Total_Time->GroupViewValue = $Report13->Total_Time->GroupValue();
         $Report13->Total_Time->CellAttrs["class"] = "ewRptGrpField5";
         $Report13->Total_Time->GroupViewValue = ewrpt_DisplayGroupValue($Report13->Total_Time, $Report13->Total_Time->GroupViewValue);
         if ($Report13->Total_Time->GroupValue() == $Report13->Total_Time->GroupOldValue() && !$this->ChkLvlBreak(5)) {
             $Report13->Total_Time->GroupViewValue = " ";
         }
     }
     // First Name
     $Report13->First_Name->HrefValue = "";
     // Last Name
     $Report13->Last_Name->HrefValue = "";
     // Paper Name
     $Report13->Paper_Name->HrefValue = "";
     // Total Marks
     $Report13->Total_Marks->HrefValue = "";
     // Total Time
     $Report13->Total_Time->HrefValue = "";
     // Call Row_Rendered event
     $Report13->Row_Rendered();
 }
 function RenderRow()
 {
     global $conn, $Security;
     global $Crosstab1;
     // Set up summary values
     $colcnt = $this->ColCount;
     $Crosstab1->SummaryCellAttrs = ewrpt_InitArray($colcnt, NULL);
     $Crosstab1->SummaryViewAttrs = ewrpt_InitArray($colcnt, NULL);
     $Crosstab1->SummaryCurrentValue = ewrpt_InitArray($colcnt, NULL);
     $Crosstab1->SummaryViewValue = ewrpt_InitArray($colcnt, NULL);
     if ($Crosstab1->RowTotalType == EWRPT_ROWTOTAL_GRAND) {
         // Grand total
         // aggregate sql
         $sSql = ewrpt_BuildReportSql($this->SqlSelectAggWork, $Crosstab1->SqlWhere(), $Crosstab1->SqlGroupByAgg(), "", "", $this->Filter, "");
         $rsagg = $conn->Execute($sSql);
         if ($rsagg && !$rsagg->EOF) {
             $rsagg->MoveFirst();
         }
     }
     for ($i = 1; $i <= $this->ColCount; $i++) {
         if ($this->Col[$i]->Visible) {
             if ($Crosstab1->RowType == EWRPT_ROWTYPE_DETAIL) {
                 // Detail row
                 $thisval = $this->Val[$i];
             } elseif ($Crosstab1->RowTotalType == EWRPT_ROWTOTAL_GROUP) {
                 // Group total
                 $thisval = $this->Smry[$i][$Crosstab1->RowGroupLevel];
             } elseif ($Crosstab1->RowTotalType == EWRPT_ROWTOTAL_PAGE) {
                 // Page total
                 $thisval = $this->Smry[$i][0];
             } elseif ($Crosstab1->RowTotalType == EWRPT_ROWTOTAL_GRAND) {
                 // Grand total
                 $thisval = $rsagg && !$rsagg->EOF ? $rsagg->fields[$i + 0 - 1] : 0;
             }
             $Crosstab1->SummaryCurrentValue[$i - 1] = $thisval;
         }
     }
     if ($Crosstab1->RowTotalType == EWRPT_ROWTOTAL_GRAND) {
         // Grand total
         if ($rsagg) {
             $rsagg->Close();
         }
     }
     // Call Row_Rendering event
     $Crosstab1->Row_Rendering();
     /* --------------------
     		'  Render view codes
     		' --------------------- */
     if ($Crosstab1->RowType == EWRPT_ROWTYPE_TOTAL) {
         // Summary row
         // First Name
         $Crosstab1->First_Name->GroupViewValue = $Crosstab1->First_Name->GroupOldValue();
         $Crosstab1->First_Name->CellAttrs["class"] = $Crosstab1->RowGroupLevel == 1 ? "ewRptGrpSummary1" : "ewRptGrpField1";
         // Last Name
         $Crosstab1->Last_Name->GroupViewValue = $Crosstab1->Last_Name->GroupOldValue();
         $Crosstab1->Last_Name->CellAttrs["class"] = $Crosstab1->RowGroupLevel == 2 ? "ewRptGrpSummary2" : "ewRptGrpField2";
         // Set up summary values
         $scvcnt = count($Crosstab1->SummaryCurrentValue);
         for ($i = 0; $i < $scvcnt; $i++) {
             $Crosstab1->SummaryViewValue[$i] = $Crosstab1->SummaryCurrentValue[$i];
             $Crosstab1->SummaryViewAttrs[$i]["style"] = "";
             $Crosstab1->SummaryCellAttrs[$i]["style"] = "";
             $Crosstab1->SummaryCellAttrs[$i]["class"] = $Crosstab1->RowTotalType == EWRPT_ROWTOTAL_GROUP ? "ewRptGrpSummary" . $Crosstab1->RowGroupLevel : "";
         }
     } else {
         // First Name
         $Crosstab1->First_Name->GroupViewValue = $Crosstab1->First_Name->GroupValue();
         $Crosstab1->First_Name->CellAttrs["class"] = "ewRptGrpField1";
         if ($Crosstab1->First_Name->GroupValue() == $Crosstab1->First_Name->GroupOldValue() && !$this->ChkLvlBreak(1)) {
             $Crosstab1->First_Name->GroupViewValue = "&nbsp;";
         }
         // Last Name
         $Crosstab1->Last_Name->GroupViewValue = $Crosstab1->Last_Name->GroupValue();
         $Crosstab1->Last_Name->CellAttrs["class"] = "ewRptGrpField2";
         if ($Crosstab1->Last_Name->GroupValue() == $Crosstab1->Last_Name->GroupOldValue() && !$this->ChkLvlBreak(2)) {
             $Crosstab1->Last_Name->GroupViewValue = "&nbsp;";
         }
         // Set up summary values
         $scvcnt = count($Crosstab1->SummaryCurrentValue);
         for ($i = 0; $i < $scvcnt; $i++) {
             $Crosstab1->SummaryViewValue[$i] = $Crosstab1->SummaryCurrentValue[$i];
             $Crosstab1->SummaryViewAttrs[$i]["style"] = "";
             $Crosstab1->SummaryCellAttrs[$i]["style"] = "";
             $Crosstab1->SummaryCellAttrs[$i]["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         }
     }
     // First Name
     $Crosstab1->First_Name->HrefValue = "";
     // Last Name
     $Crosstab1->Last_Name->HrefValue = "";
     // Call Row_Rendered event
     $Crosstab1->Row_Rendered();
 }
 function RenderRow()
 {
     global $conn, $Security;
     global $Student_wise;
     if ($Student_wise->RowTotalType == EWRPT_ROWTOTAL_GRAND) {
         // Grand total
         // Get total count from sql directly
         $sSql = ewrpt_BuildReportSql($Student_wise->SqlSelectCount(), $Student_wise->SqlWhere(), $Student_wise->SqlGroupBy(), $Student_wise->SqlHaving(), "", $this->Filter, "");
         $rstot = $conn->Execute($sSql);
         if ($rstot) {
             $this->TotCount = $rstot->RecordCount() > 1 ? $rstot->RecordCount() : $rstot->fields[0];
             $rstot->Close();
         } else {
             $this->TotCount = 0;
         }
     }
     // Call Row_Rendering event
     $Student_wise->Row_Rendering();
     /* --------------------
     		'  Render view codes
     		' --------------------- */
     if ($Student_wise->RowType == EWRPT_ROWTYPE_TOTAL) {
         // Summary row
         // First Name
         $Student_wise->First_Name->ViewValue = $Student_wise->First_Name->Summary;
         // Last Name
         $Student_wise->Last_Name->ViewValue = $Student_wise->Last_Name->Summary;
         // Roll No
         $Student_wise->Roll_No->ViewValue = $Student_wise->Roll_No->Summary;
         // Paper Name
         $Student_wise->Paper_Name->ViewValue = $Student_wise->Paper_Name->Summary;
         // Total Marks
         $Student_wise->Total_Marks->ViewValue = $Student_wise->Total_Marks->Summary;
         // Attended Date
         $Student_wise->Attended_Date->ViewValue = $Student_wise->Attended_Date->Summary;
         // Attended Time
         $Student_wise->Attended_Time->ViewValue = $Student_wise->Attended_Time->Summary;
     } else {
         // First Name
         $Student_wise->First_Name->ViewValue = $Student_wise->First_Name->CurrentValue;
         $Student_wise->First_Name->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Last Name
         $Student_wise->Last_Name->ViewValue = $Student_wise->Last_Name->CurrentValue;
         $Student_wise->Last_Name->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Roll No
         $Student_wise->Roll_No->ViewValue = $Student_wise->Roll_No->CurrentValue;
         $Student_wise->Roll_No->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Paper Name
         $Student_wise->Paper_Name->ViewValue = $Student_wise->Paper_Name->CurrentValue;
         $Student_wise->Paper_Name->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Total Marks
         $Student_wise->Total_Marks->ViewValue = $Student_wise->Total_Marks->CurrentValue;
         $Student_wise->Total_Marks->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Attended Date
         $Student_wise->Attended_Date->ViewValue = $Student_wise->Attended_Date->CurrentValue;
         $Student_wise->Attended_Date->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Attended Time
         $Student_wise->Attended_Time->ViewValue = $Student_wise->Attended_Time->CurrentValue;
         $Student_wise->Attended_Time->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
     }
     // First Name
     $Student_wise->First_Name->HrefValue = "";
     // Last Name
     $Student_wise->Last_Name->HrefValue = "";
     // Roll No
     $Student_wise->Roll_No->HrefValue = "";
     // Paper Name
     $Student_wise->Paper_Name->HrefValue = "";
     // Total Marks
     $Student_wise->Total_Marks->HrefValue = "";
     // Attended Date
     $Student_wise->Attended_Date->HrefValue = "";
     // Attended Time
     $Student_wise->Attended_Time->HrefValue = "";
     // Call Row_Rendered event
     $Student_wise->Row_Rendered();
 }
 function LoadSelectionFromFilter(&$fld, $filter, &$sel)
 {
     $sel = "";
     if ($filter != "") {
         $sSql = ewrpt_BuildReportSql($fld->SqlSelect, "", "", "", $fld->SqlOrderBy, $filter, "");
         ewrpt_LoadArrayFromSql($sSql, $sel);
     }
 }
Esempio n. 8
0
 function RenderRow()
 {
     global $conn, $Security;
     global $Report2;
     if ($Report2->RowTotalType == EWRPT_ROWTOTAL_GRAND) {
         // Grand total
         // Get total count from sql directly
         $sSql = ewrpt_BuildReportSql($Report2->SqlSelectCount(), $Report2->SqlWhere(), $Report2->SqlGroupBy(), $Report2->SqlHaving(), "", $this->Filter, "");
         $rstot = $conn->Execute($sSql);
         if ($rstot) {
             $this->TotCount = $rstot->RecordCount() > 1 ? $rstot->RecordCount() : $rstot->fields[0];
             $rstot->Close();
         } else {
             $this->TotCount = 0;
         }
     }
     // Call Row_Rendering event
     $Report2->Row_Rendering();
     /* --------------------
     		'  Render view codes
     		' --------------------- */
     if ($Report2->RowType == EWRPT_ROWTYPE_TOTAL) {
         // Summary row
         // First Name
         $Report2->First_Name->ViewValue = $Report2->First_Name->Summary;
         // Last Name
         $Report2->Last_Name->ViewValue = $Report2->Last_Name->Summary;
         // Email
         $Report2->zEmail->ViewValue = $Report2->zEmail->Summary;
         // Phone No.
         $Report2->Phone_No2E->ViewValue = $Report2->Phone_No2E->Summary;
         // Roll No
         $Report2->Roll_No->ViewValue = $Report2->Roll_No->Summary;
         // Branch
         $Report2->Branch->ViewValue = $Report2->Branch->Summary;
         // UserName
         $Report2->UserName->ViewValue = $Report2->UserName->Summary;
         // Parents No
         $Report2->Parents_No->ViewValue = $Report2->Parents_No->Summary;
         // Password
         $Report2->Password->ViewValue = $Report2->Password->Summary;
         // Confirm
         $Report2->Confirm->ViewValue = $Report2->Confirm->Summary;
         // Class Name
         $Report2->Class_Name->ViewValue = $Report2->Class_Name->Summary;
     } else {
         // First Name
         $Report2->First_Name->ViewValue = $Report2->First_Name->CurrentValue;
         $Report2->First_Name->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Last Name
         $Report2->Last_Name->ViewValue = $Report2->Last_Name->CurrentValue;
         $Report2->Last_Name->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Email
         $Report2->zEmail->ViewValue = $Report2->zEmail->CurrentValue;
         $Report2->zEmail->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Phone No.
         $Report2->Phone_No2E->ViewValue = $Report2->Phone_No2E->CurrentValue;
         $Report2->Phone_No2E->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Roll No
         $Report2->Roll_No->ViewValue = $Report2->Roll_No->CurrentValue;
         $Report2->Roll_No->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Branch
         $Report2->Branch->ViewValue = $Report2->Branch->CurrentValue;
         $Report2->Branch->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // UserName
         $Report2->UserName->ViewValue = $Report2->UserName->CurrentValue;
         $Report2->UserName->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Parents No
         $Report2->Parents_No->ViewValue = $Report2->Parents_No->CurrentValue;
         $Report2->Parents_No->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Password
         $Report2->Password->ViewValue = $Report2->Password->CurrentValue;
         $Report2->Password->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Confirm
         $Report2->Confirm->ViewValue = $Report2->Confirm->CurrentValue;
         $Report2->Confirm->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
         // Class Name
         $Report2->Class_Name->ViewValue = $Report2->Class_Name->CurrentValue;
         $Report2->Class_Name->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
     }
     // First Name
     $Report2->First_Name->HrefValue = "";
     // Last Name
     $Report2->Last_Name->HrefValue = "";
     // Email
     $Report2->zEmail->HrefValue = "";
     // Phone No.
     $Report2->Phone_No2E->HrefValue = "";
     // Roll No
     $Report2->Roll_No->HrefValue = "";
     // Branch
     $Report2->Branch->HrefValue = "";
     // UserName
     $Report2->UserName->HrefValue = "";
     // Parents No
     $Report2->Parents_No->HrefValue = "";
     // Password
     $Report2->Password->HrefValue = "";
     // Confirm
     $Report2->Confirm->HrefValue = "";
     // Class Name
     $Report2->Class_Name->HrefValue = "";
     // Call Row_Rendered event
     $Report2->Row_Rendered();
 }