Invoice Report Query

Invoice Report Query

Hi All,

I need to create an Invoice Report displaying all monthly invoiced jobs WITH each invoice showing the its component products, quantities ordered, list prices etc...

i.e. Invoice 23012 - might contain three products of various quantities ordered within. This would create a report with many rows as each particular invoice would have on average three products - This is what I need though

When I try and include Product Details as a column; All I ever get is a hyphen/dash in the relevant field.