web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Advanced Reports in CRM

(0) ShareShare
ReportReport
Posted on by 570

Hi All,

I am facing a challenge which I need to complete successfully.

Requirement:

1) I have a custom entity name New_ActivityTrail. The records in this table are stored based on triggers which gets fired whenvever a new Acitivtiy get created/ an existing activity's owner gets changed.

2) Since activities can be related to different entities, such as Projects, Contacts, Lead, Quote, Order, et al. using the RegardingObjectId, I also need a functionality in the report which is whenever the report is opened from Project then only those activities realted to that Project should be shown in the Report. If it is opened from Lead then it should show only activities related to that Lead. and so on.

3) I have created the triggers and its storing the records well in the table new_activitytrail.

 Now since I am new at reports I need help in learning and understanding how to pass the parameters of the opened activity ( see point# 2)

Since the data will be storing the reference of other entites, I need to fetch the user-friendly value by joinig to that table.

Please provide me any help possible in terms of links/samples anything.

Thank you very much in Advanced. Please write back if you need more understanding on this

Utsav Acharya.

utsav.acharya@ennovatetech.com (Quick contact )

*This post is locked for comments

I have the same question (0)
  • Alan Garcia Profile Picture
    2,020 User Group Leader on at

    Hi Utsav,

     All the information you'll need for custom reporting can be found in the SDK documentation here: http://msdn.microsoft.com/en-us/library/bb955093.aspx

    With regard to retrieval of the friendly names from linked entities, you won't need to worry about that if you stick to using the Filtered Views.  This will also give you the added benefit of carrying forward user security as it resides with your configured Security Roles on the Entities/Areas.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans