Hello and welcome!
From your nice description, it sounds to me like you've defined the template for the Prod ID and Name as an "Append" template. I'd simply recommend that you change that setting to a "Footer" template.
Footer templates want to extract data which appears after the fields defined in the Detail template.
I hope that I haven't misunderstood the layout of the report, and how you've modeled so far.
If this does not resolve your challenge, would you mind posting a sample (with private data replaced with x's and 9's) using the Code button? A picture is worth a thousand words and all that...