Posted: 2 Feb 2017 13:59 EST Last activity: 3 Feb 2017 8:37 EST
Adhoc Reporting doesn't allow you to configure outer joins
Currently, I have a customer that is using the adhoc reporting tool. They drag properties over to be part of the report. If that property is part of a page list, it inherently creates an inner join. This causes the results to only include cases that have values in the pages list. If that page list is unpopulated, it doesn't return the case. If we modify the report through the designer, you can easily put this outer join in, but the users don't want to come to us to create/modify their user reports. So, is there a way through the adhoc tool to indicate an outer join.?
***Updated by moderator: Lochan to add Categories; close post***
This looks a duplicate of another question raised just before your post. We believe that troubleshooting on 1 single discussion thread would avoid confusion to the community members while assisting you. Therefore, I will be closing this thread to future replies. Please add in the inputs requested by Arun_Mahanty in the as a reply in the other post: Index- Class joins in Adhoc Reporting feature - User not able to modify join type