I would like a report to show a tech's availability based on calendar entries for vacation/ sick time etc.

columns:

tech name (selectable - select one or multiple names)

month (selectable - current or previous)

date

reason for not being available  i.e. on vacation, sick, personal time etc.

total of each "reason"

 

running 9.0 build 9008  MSSQL