Customer (9999) movimento(05) Quantidade(100) Product(IS0001)..in Customer (9999) movimento(55) Quantidade(050) Product(IS0001)..out Customer (9999) movimento(05) Quantidade(250) Product(IS1000)..in Customer (1000) movimento(05) Quantidade(150) Product(IS0001)..inReport,
Customer 9999 Product Stock IS0001 50 IS1000 250 Customer 1000 Product Stock IS1000 150so, in this case the report must have 3 lines (the select need to give 3 lines to do the report)