AnsweredAssumed Answered

how to do a report with that includes sub records

Question asked by matronryan on Dec 12, 2011
Latest reply on Dec 12, 2011 by matronryan

Title

how to do a report with that includes sub records

Post

I have a product table and a related sub product table.  I want to be able to run a report that lists the products and where a product has a sub product/s list those below the product.  Where a product has more that one sub product the report only displays the first subproduct.  

I've also tried using a portal in the report which works but that means I have to set the portal size for the maximum number of sub products and this looks very messy for products that have none or one subproduct

 

Any help greatly appreciated

Thanks 

Outcomes