Formatting A Report

Anthony1312002

Has anyone our there come across a script in PHP that formatts a report to look something like a crystal report. Like the example below. As you can see, each Department would have it's own set of Supervisors who in turn have employee under them. Then the report groups and subtotals the hours for each department and supervisor. Has anyone seen anything like this? Below is a script I'm using thats creating a report but not in the format I'm looking for below.

Department: Lockbox Admin
Supervisor: Tom Tucker

Records:
ANumber FirstName LastName Service Date Hours

A559677 Martha Shuttleworth 2003-06-15 25

Department: Retail Lockox
Supervisor: James Davis

Records:
ANumber FirstName LastName Service Date Hours

A559895 June Morganton 2003-06-06 16

PHP SCRIPT

if ($opt1==1) {

$Query = "Select ANumber,FirstName,LastName,Department,TeamLeader,date_format(DateOfService,'%M/ %D/ %Y') AS ServiceDate,NumberOfHours,ActivityType,
Org,Description,TimeTakenWhen,SiteID
FROM activitytracking WHERE DateOfService BETWEEN '%".$POST[txtStartDate]."%'
AND '%".$POST[txtEndDate]."%' AND Department Like '%".$POST[Departments]."%'
AND SiteID Like '%".$POST[Sites]."%'
GROUP BY ActivityType,DateOfService,Department,ANumber,TeamLeader,Description
ORDER BY LastName,DateOfService";

$result = mysql_db_query ($DBName, $Query, $Link);

//Fetch the results frm the database
print "<table border=1 align=center>";
print "$Sites Community Service Report By Activity. ";
print " For the Date Range running between $POST[txtStartDate] AND $POST[txtEndDate]. ";
print " YOU MUST PRINT THIS REPORT IN LANDSCAPE TO VIEW ALL RECORDS.";
print "</table>";
session_register("logname");
print "Report Printed By $logname";

print "<table border=1><tr><th bgcolor=#F0F0F0>Employee Number</th>";
  print "<th bgcolor=#F0F0F0>First Name</th><th bgcolor=#F0F0F0>Last Name</th><th bgcolor=#F0F0F0>Department</th><th bgcolor=#F0F0F0>Team Leader</th>";
    print "<th bgcolor=#F0F0F0>Date Of Service</th><th bgcolor=#F0F0F0>Hours</th><th bgcolor=#F0F0F0>Activity</th><th bgcolor=#F0F0F0>ORG</th><th bgcolor=#F0F0F0>Comments</th>";
       print "<th bgcolor=#F0F0F0>Involved When</th><th bgcolor=#F0F0F0>SITE</th></tr>";

while ($Row = mysql_fetch_row ($result)) {

print " <tr>";

print "<td align=Center> $Row[0]</td>
<td align=Center>$Row[1]</td>
<td align=Center>$Row[2]</td>
<td align=Center> $Row[3]</td>
<td align=Center> $Row[4]</td>
<td align=Center> $Row[5]</td>
<td align=Center> $Row[6]</td>
<td> $Row[7]</td>
<td> $Row[8]</td>
<td> $Row[9]</td>
<td align=Center> $Row[10]</td>
<td> $Row[11]</td>";

print "</tr>";

}

$Query = "Select Sum(NumberOfHours) AS Hours,Count(NumberOfHours) AS CountedHours
FROM activitytracking WHERE DateOfService BETWEEN '%".$POST[txtStartDate]."%'
AND '%".$POST[txtEndDate]."%' AND Department Like '%".$POST[Departments]."%'
AND SiteID Like '%".$POST[Sites]."%'";

$result = mysql_db_query ($DBName, $Query, $Link);

while ($Row = mysql_fetch_row ($result)) {

print " <tr>";

print "<td align=Center bgcolor=#F0F0F0>///</td>
<td align=Center bgcolor=#F0F0F0>///</td>
<td align=Center bgcolor=#F0F0F0>///</td>
<td align=Center bgcolor=#F0F0F0>///</td>
<td align=Center bgcolor=#F0F0F0>///</td>
<td align=Center bgcolor=#F0F0F0>Total Hours</td>
<td align=Center bgcolor=#F0F0F0>$Row[0]</td>
<td align=Center bgcolor=#F0F0F0>///</td>
<td align=Center bgcolor=#F0F0F0>///</td>
<td align=Center bgcolor=#F0F0F0>///</td>
<td align=Center bgcolor=#F0F0F0>///</td>
<td align=Center bgcolor=#F0F0F0>///</td>
<td></td>";

print "</tr>";
print "</h3>";
}
}