Report or list of acounts with no meetings in last 3 months

[stevec]

Hi,

I'm looking for a way to display a list of accounts (filtered on a custom field - "CRM-group") with no related meetings in the last three months.

I've tried using PRO reports but the filters and grouping options can't quite do it (as far as I can tell) as the meeting start date criteria would need to be in the join clause rathar that the where clause.

Does anyone have an idea on how to do this via the sugar interface?

Thanks

[dtokeefe]

With Sugar Enterprise, you can create a custom query to achieve this. In other editions, a quick solution is to create create a custom view on the Accounts module, that displays a table that you generate with your SQL query.