Report only active relations to an account

[MicKress]

Hi, I tried to create a report which shows me all active contact relations to an account. Unfortunately the criteria is not shown in the field list for the report. Do I male something wrong? Regards Michael

[Maximus]

Hi,
please make this report:

[MicKress]

Hi, thank you. I did it, but there are also contacts in list which aren‘t set active in this relation. I cannot set a filter for contactIsInactive.

[Maximus]

What do you mean when you say "active connection"? Perhaps you can explain this more explicitly with attachments?

[MicKress]

In the detail view of contacts I can set an account as inacrive. In a report I want only the active contacts. IsInactive is a bool field located in the relation table contacts-accounts.

[Maximus]

There is implemented an opportunity to add a condition into the report filter (field (Account inactive)). When I have tested it caused an error. We will try to find out what want wrong.

[MicKress]

Same happend to me that it caused an error when I chosed the condition Account inactive. Thank you.