# $Id: slipsummary.rep,v 1.4 1999/11/08 18:50:53 billf Exp $

TITLE: Slip Counts by Status Code
VERSION: 1.1
REQUIRES: 0.40.01
DATASET: slips
VAR1:
{
	text = Enter a start date
	dtype = date
	default = 05/12/98
}
VAR2:
{
	text = Enter an end date
	dtype = date
}
SQL:
{
	select count(slips.sid), slips.status, status.flag, status.label
		from slips, status
		where slips.status = status.flag
		group by slips.status, status.flag, status.label
}
COL1:
{
	label = Status Code
	display = label
}
COL2:
{
	label = Number of slips
	display = count(slips.sid)
}
