I have a custom object that represents purchases in an online shop. Each instance of this object has an optional relationship to an account and at least one relationship to another custom object, which represents items in the order. For the visually minded, here's an entity diagram:
I want to build a report based around these Order objects, but filtered based on details from the parent Account and the child Items.
How can I do this?
I've tried using a Joined report, but the filters appear to operate independently for each report type. I.e. if I have one filter based on the account and another based on the items, I get a row for each order that gets through either of the filters. I need to only return rows that match both filters.
Any help / advice appreciated.