#
# a sample report.  Neat, huh?
# $Id: slipsbytech.rep,v 1.3 1999/11/08 18:50:53 billf Exp $
#

TITLE: Open slips by Technician
VERSION: 1.1
REQUIRES: 0.40.01
DATASET: slips
SQL:
{
	select count(slips.sid), slips.currtech, status.label, status.flag
		from slips, status
		where slips.status = status.flag
		group by slips.currtech, status.label, status.flag
}

COL1:
{
	label = Current Tech
	display = currtech
}

COL2:
{
	label = Status Code
	display = label
}
COL3:
{
	label = Number of slips
	display = count(slips.sid)
}
