Lines Report only returns one value of list

[buckbuck]

I have a typical product line data base relationship - Contact-Invoice-Lines-Products.

One Lines field is called 'Is_FB'  It calculates if the 'Colour' field is "Flat Black", returns field 'Quantity'. If (PRODUCTS::_00.04_Product_Colour = "Flat Black"; Quantity; " ")

I have a Report based on the Lines Table. The intention is to show sub-summaries of the products by 'Product Name' (Products) and field values from the Lines table 'Is_FB' ect...

Problem: My report returns only one line per Product Name

For example, if my client orders product "Blanket" in two colours the report shows on one of the colours under sub-summary Product Name

Based on what I have said so far, can anyone tell me how my Report needs to be modeled to see the two colours.

 

Thanks

Matthew

[buckbuck]

I figured this problem out. My sub-summary table should have been based on the kp_Lines ID

[Lee Smith]

Glad to hear that.