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

TITLE: Recent Slip Activity
VERSION: 1.1
REQUIRES: 0.40.01
DATASET: slips
VAR1:
{
	text = Enter a start date
	dtype = date
	default = today
}
VAR2:
{
	text = Enter an end date
	dtype = date
	default = today
}
SQL:
{
	select slips.sid, slips.priority, status.label, slips.l_tech, 
			slips.l_activity, slips.o_date, slips.problem
		from slips, status
		where slips.status = status.flag
		and slips.l_activity >= VAR1
		and slips.l_activity <= VAR2
		order by slips.l_activity desc, slips.priority, slips.l_tech, slips.sid
}

COL1:
{
	label = SID
	display = sid
}
COL2:
{
	label = Priority
	display = priority
}
COL3:
{
	label = Status
	display = label
}
COL4:
{
	label = Last Tech
	display = l_tech
}
COL5:
{
	label = Last Activity
	display = l_activity
	dtype = datetime
}
COL6:
{
	label = Open Date
	display = o_date
	dtype = date
}
COL7:
{
	label = Open Date
	display = o_date
	dtype = date
}
COL8:
{
	label = Synopsis
	display = problem
}


