I was wondering if there is any way to add a field to a report that dynamically counts records from a related form.  Specifically, I have Form A which holds Employee Names, and Form B which holds Tasks, with a lookup to the employee's name in Form A.

I'd like to have a report based on Form A which includes a count of the number of tasks assigned to each employee from Form A.  I think this can be done with a pivot table, but was hoping to do it in a regular report view.

Thanks for your help.