Multiple entities in one view / report

(0) Share

Report

Posted on by Klaudia

Dear All,

I am trying to build a view from multiple entities: Contacts, activitypointer and one custom: payment.

Relationships:

Contact 1:N with Activitypointer

Contact 1:N with payments.

I would like to build a view that will present contacts who made payment in the last week but no action was directed to them. Is this possible with CRM 2013 out of the box?

Let me know if you can help.

Regards,

Klaudia

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

Hi Klaudia,

You can use Advance find to achieve it.

But your condition ‘last week’ is just for payments? or both for payments and Activity?

If it is just for Payment, you can follow step1.

1.Contacts with payments last week and no activity.

(1) Click Advanced Find button.

(2) Select Contacts entity and View that you need. then add a reference entity and set condition.

If ‘last week’ condition is also for Activity, you need the FetchXML builder – it is part of a larger set of tools called the XRM ToolBox.

2.Contacts with No Activities last week View using FetchXML

(1) Download XRM ToolBox.

https://www.xrmtoolbox.com/

(2) Once you have downloaded and installed it, you’ll open the view you created in step1, and edit it.

3.reopen the view in advanced find.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
Klaudia 5 on at

Like (0)

Report

It works, thanks for your help!

Was this reply helpful? Yes No