I have a report called "Current Active Jobs." When a job is complete, it moves to the "Inactive Jobs" report. Each job has many tasks and I have set up a Gantt chart report on the Tasks table for the tasks and I use the dynamic filter to filter the jobs by [Job Name] which is a lookup field to the Jobs table. There are a couple issues. 1)Some of the job names from the Current Active Jobs report aren't appearing in the filter, and 2) I would like to have the job names no longer appear on the filter once the job is moved to the Inactive Jobs report. Is this possible?