There are two things you'll have to do:
1. Joins - make the join FROM the customer TO the activity a left outer join.
2. Selection Criteria - If you've got a filter on anything in the activity table, you'll need to account for null data. So, for example, if you're filtering on date, you'll do something like this:
(IsNull({activity.CustomerID}) OR {activity.Date} > {?Date Parameter})
Note that I surrounded this whole statement in parentheses - if you have multiple filters, you'll need to have these parens in order to get this to work correctly.
-Dell
IP Logged
