I would like to use a filter to select by supervisor ID and show all tasks assigned to active employees under the selected supervisor, including tasks assigned to the supervisor selected. I'm doing ok with all the employees tasks but I've been unable to retrieve the supervisors tasks along with those under him/her. I'm using Crystal XI; SQL Server 2000. I tried a cascading parameter but that didn't seem to work either. Any ideas? I'm also stumped on how to write the selection formula when using a cascading parameter.