You need to sign in to do that
Don't have an account?
Nazeer Ahamed
Exception report on contacts and accounts
I need to generate a typical report on all contacts that have never had any activities (no Cases, no Opportunities, no Emails, and no Events) the last 2 years. Means idle contacts need to be retrieved and same thing for account.
Challenges are,
Reports on lot of objects which is tackled by custom report types which allows such a way like contact-> case/opportunity –> activity.
- I need to capture date/time stamp of most recent case, in case of activity “Last activity” help us.
- Also need to avid duplicates caused by one to many relationship(Contacts-Case)
There is any field in case like "Last activity" in activity.
Is i posted a wrong query or in area. Dont make me feel like ignored. looking forward to hear from you people.. :smileyindifferent:
Message Edited by SF Prince on 02-26-2008 02:41 AM
hi,
Thanks for your reply. me itself pointed that point in my first post. but it is not enoughth. since lot of chances are there for cases with no activity and my exact req., is to capture contact with no case,opportunity and activy. which means i need to identify most idle contacts. any idea?
Thx-SF Prince
Message Edited by Nazeer on 02-27-2008 04:24 AM
-Nazeer
https://sites.secure.force.com/appexchange/listingDetail?listingId=a0N30000001tc1DEAQ