Lead and Activity Reports

Lead and Activity Reports

Is it possible to run relational reports across multiple modules.  I want to run a report that filters particular leads by status and source that have particular words in an activity or a particular priority on an activity.  I have tons of uses for filtering this way, but as I can see you can only look at these 2 modules separately.   Am I missing something?