Location Sales - week commencing Jan 8th
setTableAttr('border="0" cellspacing="1" width="300" ');
$grid->setDateFormat('j M y');
$grid->setColClass('head1,head1,head1,data1,data1,data1,head1,data1,head1,data1');
$grid->setHeaderClass('head1');
//$grid->hideColumn(3);
$grid->setAlign(1,'C');
$grid->setAlign(2,'C');
$grid->setAlign(3,'C');
$grid->setAlign(4,'C');
$grid->setAlign(5,'C');
$grid->setAlign(6,'C');
$grid->setDecPlaces(7,0);
$grid->setDecPlaces(9,2);
$grid->setDecPlaces(5,2);
$grid->setSpan (1,0,2);
$grid->setSpan (3,1,0,3);
$grid->setSpan (4,0,2);
$grid->setSpan(5,0,0,3);
$grid->setSpan (6,1);
$grid->setSpan (8,1);
$grid->setAlign(3,'C');
$grid->setOnChange(4,0,1);
$grid->noHeadings();
$grid->display();
// with printer friendly styles
$sql = "select datesold,locname,sum(qty) as qty,sum(value) as sales
from baagriddata
group by datesold, locname
order by datesold,locname";
$grid2 = new baaGrid($sql);
$grid->setTableAttr('border="0" cellspacing="0" width="400" ');
$grid2->setHeaderClass('TLB,TLB,TLB,border');
$grid2->setColClass('L,L,L,LR');
$grid2->setOnChange(0,1,2);
$grid2->setSubTotalClass('T,T,TLB,border');
$grid2->setTotalClass(',,TLB,border');
$grid2->setTotal(2,0);
$grid2->setTotal(3,2);
$grid2->setHeadings("Date\nSold,Location,Quantity,Sales");
$grid2->setDateFormat('D, jS M');
$grid2->setWidth(0,'20%');
$grid2->showColNumbers(0);
$grid2->display();
?>