AnsweredAssumed Answered

Reports shows records that only have values in the related modules

Question asked by Alexandru Pacuraru on Oct 7, 2016
Latest reply on Oct 7, 2016 by Ishani Lad

We have tried to create a report with contracts filtered by parent and child customers. When we run the report and verified the records we found that not all the the contracts were being returned.

Then we tried to filter a specific customer and still not all the contracts for that customer were being returned.

When we analyzed we saw that the report returned the contracts that only had values in "Member of" field (a relationship type of field).

As you can see in the attached image, the same ID (the customer ID) appears in filters but the results show only the one with a value in "Member of" field.

 

We continue to analyze the situation and tried a different case.

We filtered all the contracts that belongs to a child customer and we added the Destination column.  

In this case we found that only the contracts that had a destination appeared in the report. The ones without a destination but assigned to the same customer, did not show up in the report.

 

Therefore the reports fetches the records that have values in all the related modules.

We think this is because the query used to fetch the records uses an INNER JOIN statement instead of an OUTER JOIN

 

Is there an workaround for this type of situations?

 

Thank you!

Attachments

Outcomes