title: Crystal Reports 2011 calculate number of days worked in a given date range
body: <p>I am trying to come up with a utilization report for artisans. The report prompts for a start date and an end date. It should then check in the Leave table if an artisan was on leave on any of the days in the date range and add the leave days to weekends and public holidays in the specified date range and then subtract the total count of the above from the number of days in the date range (this is done to remain with only a count of the days when the artisan was actually at work). How best can I achieve this using Crystal Reports?</p>