I have to produce two simple reports multiple times a day and at the moment I need to run a number of reports to be able to produce this.

Could you please provide a New Query Report sql script that will show the below details.  I would also need to be able select amend the script easily to show either a date range, or Today; Yesterday; thisweek etc.  To clarify Resolved should include:

Report 1 - By Technician

Agent	Open Events	# Open out of SLA	# Logged	# Total Resolved	# Resolved in SLA	# Total Closed
Tech1
Tech2
Tech3
Tech4

Report 2 - By Date

Date	Open Events	# Open out of SLA	# Logged	# Total Resolved	# Resolved in SLA	# Total Closed
dd/mm/yy
dd/mm/yy
dd/mm/yy
dd/mm/yy

Version

: 9.0 Build 903

Many thanks,

Lisa