I need to print a usage report for a customer showing them how many of each part number they have purchased through us during a given time period. I have created about 20 different subsummary reports and followed all the instructions I've been able to find online; none of them are producing the information I need. The closest I can get is a report that produces a list of each time an item was purchased, and the qty purchased (sorted by part numebr), but the total of the qty purchased only yields the qty in the LAST order. The tables are linked. The report in based on the Line Item table.
Any hints on what else I can try?