Problems modifying out-of-the-box report Activites

Yikes!  Updating the default reports in MS CRM is scary business - it can certainly be done, but they tend to be very complex configurations and are prone to creating errors unless you spend a lot of time debugging your work.  Some suggestions:

(1) Consider creating your own activity report to deliver what your client needs (have you tried the Report Wizard?  Sometimes this is all that you need - if not, then try writing a report in SSRS).

(2) The default Activity Report in CRM does return all regarding object types (object type 3 is the Opportunity object type).  So I'm not sure why your default report is not showing activities regarding other entities.  Some possibilities:
* The default report was already modified.  Try re-loading the default report to see if it works
* The user is running the report from the Opportunity entity - and the report is auto-filtering to only those activities that are regarding the Opportunity(ies) in question
* The Default Filter for the report has been altered.  Try changing this in CRM (Reports | Activities | More Actions | Edit Default Filter)

I think that there are missing 2 filters, Regarding(Account) and Regarding(Contacts). Currently Activites, Cases, Opportunities and Users are showing in the filters. How can I add Contacts and Account to the CRM filters?

I did go to CRM (Reports | Activities | More Actions | Edit Default Filter) but the dropdown box is placed into the Activities filter and therefore only possbile to add them into the activites filter. How can I add the filter to the report so I will be having those filters:

Activites
Cases
Opportunites
Users
Accounts
Contacts

You cannot easily add these two groups to the filters - but you SHOULD be able to use existing filters to filter on these results.

Before I explain that, let me make sure I am understanding what you are trying to do:

Your initial inquiry led me to believe that they can ONLY see Opportunities (regardingobjecttypecode=3) in the report.  However, by default, you can report on EVERY activity in CRM using this report (not just activities that are related to opportunities).

From your second reply, it sounds as if they can see all of the activities, but they want to ALSO be able to filter them by a specific Contact or Account.

If I am correct in assuming that the latter paragraph is what you are after, there is a simple process that SHOULD work for handling the filtering.  I've outlined it below, but it appears that this does not work (which is a bug with the report in CRM - I've reported it to Microsoft in hopes that it will be fixed.)  I'm including the process below only so if someone finds this in the future, they can give it a try:

(1) Reports | Activities | Double Click.  You will see the report filter.
(2) Click the "Select" link under Activities
(3) Scroll down until you get to Regarding (Account) and select it
(4) Click the Select link under thet Regarding (Account) area and select whatever criteria you wish to add to the filter
(5) Repeat for Contacts if you wish to filter by that.

Okay, since that doesn't work, what are the options until MS gets around to fixing this?

(1) You could create a view on the Activity entity that gives them what they want - then export it to an Excel Pivot Table so they can get the summary that they're looking for (simple)
(2) You could create a custom report in the report wizard (simple)
(3) You could create a custom report in Visual Studio (fairly complex)
(4) You can keep trying to modify that default report (not recommended - VERY complex)

If it were me, I would go for option #2 or #3.  I've modified the reports that come with CRM before - it is a painful process because the queries behind these reports tend to be highly complex.  If you do decide to modify the existing report, keep in mind that the reports built into CRM are usually multiple different reports "rolled into 1" - so the bar charts on the Activities report are really a bunch of reports that are laid one ontop of the other ... you need to find the real report and dataset that you want to update to get everything working the way you want (or you may need to update multiple different bar charts to work with your revised report).

Sorry to not be able to give you a solid answer on this one.  I hope one of the above options turns out well for you.

CustomerConnectMicrosoftCRM.png

Thank you very much for your detail answear. I apologize but I think that I haven't been to clear about what I'm trying to achieve here.

I attached a pdf document where I go through step by step what my client wants.
Detail-regarding-out---of---the-.pdf

Ok thank you very much for your help, I look forward to see if you have an quick fix.

Thanks again for your help.