Simple Report With Group Headers

ASP

Dim DepName
Function departments_BeforeShowRow(Sender)

  If DepName = departments.department_name.Value Then
     departments.department_name.Visible = False
  Else
     departments.department_name.Visible = True
     DepName = departments.department_name.Value
   End  If 

End Function

PHP

function departments_BeforeShowRow(& $sender) {
global $DepName;
global $departments;

  if ($DepName == $departments->department_name->GetValue()) {
     $departments->department_name->Visible = False;
  } else {
     $departments->department_name->Visible = True;
     $DepName = $departments->department_name->GetValue();
  } 

}

Perl

sub departments_BeforeShowRow() {

  if ($DepName eq $departments->{department_name}->GetValue()) {
     $departments->{department_name}->{Visible} = 0;
  } else {
     $departments->{department_name}->{Visible} = 1;
     $DepName = $departments->{department_name}->GetValue();
  } 

}

ColdFusion

<!---departments_BeforeShowRow --->
  <CFPARAM Name="DepName" Default="">
  <CFIF DepName EQ flddepartment_name>
    <CFSET hideDepartment_name= True>
  <CFELSE>
    <CFSET hideDepartment_name=False>
    <CFSET DepName=flddepartment_name>
  </CFIF>

Java

//'departments_BeforeShowRow

  String depName = (String) e.getPage().getRequest().getAttribute("departmentname");
  if ( depName == null ) {
    depName = "";
  }
  if (depName.equals(e.getGrid().getControl("department_name").getValue()) ) {
    e.getGrid().getControl("department_name").setVisible(false);
  } else {
    e.getGrid().getControl("department_name").setVisible(true);
    e.getPage().getRequest().setAttribute("departmentname", e.getGrid().getControl("department_name").getValue());
  }

.NET

1. If you are using C# or VB.Net, modify the HTML as follows:

<!-- BEGIN Row -->
  <tr id="departmentsNameTR" runat="server">
    <td bgcolor="#336699" colspan="3"><font color="White">{department_name}</font></td>
  </tr>
  <tr>
    <td class="ClearDataTD">{Label1} </td>
    <td class="ClearDataTD">{emp_name} </td>
    <td class="ClearDataTD">{title} </td>
  </tr>
  <!-- END Row -->

2. Then within the code for the page, add the variable called DepName below the section that ends with the text 'End Forms Definition

VB.Net

'End Forms Definition 
  Dim DepName As String 

C#

//End Forms Definition 
 protected String DepName;

 

Then add the following code in the Before Show Row event of the grid.

VB.Net

'departments_BeforeShowRow

  If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then
    Dim departmentsNameTR As Control = e.Item.FindControl("departmentsNameTR")
    If DepName = DataItem.department_name.Value Then
       departmentsNameTR.Visible = False
    Else
       departmentsNameTR.Visible = True
       DepName = DataItem.department_name.Value
    End If 
  End If

C#

//departments_BeforeShowRow

  if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) {
    Control departmentsNameTR = e.Item.FindControl("departmentsNameTR");
    if (DepName == DataItem.department_name.Value.ToString()) {
       departmentsNameTR.Visible = false;
    } else {
       departmentsNameTR.Visible = true;
       DepName = DataItem.department_name.Value.ToString();
    } 
  }