First see if you can create a summary report such as that shown in this tutorial: Creating Filemaker Pro summary reports--Tutorial
If you can do that, but really want to list each product in a different column, then the next step will be to set up a "cross tab" version of this same report using one row portals, portal filters and summary fields--a much more complex undertaking.
Thank you Phil,
I believe I do really want to undertake option 2. Do you know of any examples of people doing this that I could use as a reference?
Upon some further experimenting I am able to get each products quantity listed for each order, but how can I get the totals over a date range in a summary field?