Hi

I'm new user of FM and I create 4 Tables in my DB. There are

Product:kpproductid---Selldetail:kfproductid,kfsellid----Sellinvoice:kpsellid,kfcustid----Customer:custid,

and I want to have a layout base on table Product which will have the sum of qty. of each product sold to each customer(sort by sum of qty). I've tried to do that but the summary field "sumproduct" that I create in product table show the total qty. which sold to all customers. It is not the figure that I want. Pls. show me how to create it.

Thanks

If you need a report of products sold by customer, you need to do a subsummary report using a layout based on the Selldetail table. You have a quantity sold in the selldetail table, right? Create a summary field Total of Quantity Sold and put that in your subsummary part when sorted by product, and the subsummary part when sorted by customer. Sort by product then by customer.

You don't mention date ranges, but that can be handled by doing a find in this table before producing the report.

Thanks for your help and I've created the report but it has some problem. In summary report, it can show the summary figure but I can't find the specific record (specific productid) because the report has no body part. It has header and summary parts. When I put body part in report it will show many lines of sold product and it's look bad. Another way that I want is making portal (base on selldetail table) and put in Product layout. I've tried but not success cause that portal can not show the sum qty base on productid of each customer. There are some comments about using new table occurance but it does not clear for me. Can you help me again.

Thanks