Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
In CRM 365 we have had to export our data to excel and create a pivot table to manage the activity reports for our sales people because the canned report for activities seems to be missing certain activities. Such as with one user the CRM report says that they did four tasks, nine phone calls, and seventy three emails. Though once I export it to excel it says four task, thirty six phone calls, and ninety six emails. I feel like there is just something that I am missing please advise.
Update I found out that the canned report for Activities only pulls the activities that are regarding opportunities. So If I may adjust my question to be: How can I change this report to include the activities from Leads, Contacts, Oppurtunities, Accounts.
It depends what, if any, information you need to display about the Leads, Contacts, Opportunities and Accounts in your report. If you don't need to display any fields from them, then it should be fairly straightforward to just change the filtering around the regardingobjectid and/or the join from the activityparty.partyid field.
However, if you want to display fields from the Leads, Contacts, Opportunities and Accounts in your report, then it gets more complex, as you essentially need a query for each. If the report is SQL-based, then you can do this with Unions, but if the report is FetchXml-based I think you can do this with multiple outer joins, and then an expression in the report to consolidate the names (as each name would come from a different field)
I need report that shows the email, phone, task, and Opportunity close Count in a graphical representation. As I have said the Report "Activities" that is built in has this but it only pulls the Activities that are related to Opportunities. I need it to be related to Leads, Contacts and Accounts also. I have down loaded the report which appears to be a fetch XML file. So I suppose I am seeking guidance on how to alter this fetch XML to pull from Leads, Contacts and Accounts.
Business Applications communities