Hi,
We are on multi tenant and have limitations with the Adhoc Reporting. We are finding limitations with the following
1) If we start with a master table that is higher granularity and join to child tables, it acts more like a left outer join (rather than an inner join). for example: If we need all deliveries not invoiced and want to list charges, if we start with status of 60 for deliveries and join to oochrg, we will get all deliveries not invoiced whether they have no charges or not (charge fields are blank), but if we start with the more granular child table (aka oochrg), then we can't filter out only those that are delivered and not invoiced (parent)
2) When joining from a parent to a child, if the child has fields that are part of the PK, for example a sequence, it has to be included in the join. We can't get for example, all deliveries not invoiced, and grab all the charges for it because the last field on the charges table has a seq number. WE have tried to create a new sort option w/o the sequence fields but ahs keeps adding it back.
