I have a problem that I thought was working but is not.
When I run a report, it lists multiple products ordered, with the ordered quantity.
What I want the report to do is summarize the same product types, and total the amount reserved for that particular product.
In report design, when I crate a grouping, it does not give me the option to group by product name, even though product name field is in the related query, and in the report.
How do I create this sort? Thank you!
Some screenshots are attached.