Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: BCM 2010: How to create report with contact history?

31 Jul 2011   #1

Windows 7 x64
BCM 2010: How to create report with contact history?

One report I would like to be able to generate within BCM2010, is a report of either accounts or business contacts which shows the date and type of the most recent contact. I do not see this as an option in any of the reports. Please show me how to create such a report (without having to write a SQL query...)

My System SpecsSystem Spec
01 Aug 2011   #2

Windows 7 x64

Select C.FullName, Q.LastContact, U.AssignedTo
From ContactDetailsTable U, ContactMainTable C
Inner Join (
Select ContactID, MAX(ActivityDate) as LastContact
From ActivitiesTable, ActivityContacts, ContactMainTable
Where ActivitiesTable.ActivityID = ActivityContacts.ActivityID AND
ContactID = ContactMainTable.ContactServiceID AND
ContactMainTable.Type = 1
Group By ContactID) As [Q]
On C.ContactServiceID = Q.ContactID
Where U.ContactServiceID = C.ContactServiceID
Order By LastContact DESC
My System SpecsSystem Spec

 BCM 2010: How to create report with contact history?

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar help and support threads
Thread Forum
WLM 2011 -how do I create a new Contact list
Just moved to Windows 7 from XP and struggling with Windows Live Mail (amongst other things!). Very basic question but I can't find how to add a new Contact list.
Browsers & Mail
Contact categories and use of templates in Outlook 2010
Hello, in Outlook 2010 I have a large list of contacts all divided into categories with 50+ e-mail addresses each. I normally select the category and create a new e-mail for these contacts, paste a signature of text to the e-mail, copy/paste the subject and mark the e-mail with high importance and...
Microsoft Office
Outlook 2010 Contact Groups not working
I've been using Contact Groups on previous computer, but when I moved over to my new PC and loaded Office 2010 along with Outlook, the contacts groups in OUtlook does not seem to work. None of the groups I had before were imported, although I have imported all of the contacts themselves. When...
Microsoft Office
Import contact persons to Outlook 2010
I have formatted my HD and installed office 2010. Before formatting I exported my contact persons (Outlook 2003) to a pst file, and now I try to import them to my new Outlook, but no matter what I do, nothing happens. I'd really appreciate if someone could tell me exactly how to do it. Thanks a...
Microsoft Office
Outlook 2010 Contact Group Question
So, my googling skills found nothing (couldn't get the search terms specific enough, I think), so I'm throwing it out to the peanut gallery. For purchasing in my department, I email my boss the parts, and cc his secretary. He approves the order, and she purchases the parts. I was wanting to...
Microsoft Office
Business Contact Manager for Outlook 2010
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 08:27.

Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App