Originally written by John Hardwick, last updated Apr 29, 2026, on the Swan Retail knowledge base (FRS).
Part of: Sales Reports
This report is designed to show sales of measured goods broken out by product group.
Crystal report name Sales by Product Group 10
This report has been replaced with the Sales by Group report. This new version offers collation by product or sales departments.
Click to view details Sales By Group
Selection Criteria
Run time choices, user selectable.
-
Transaction Date Range
-
Restricted Selling Location(s)
-
Supplier(s)
-
Product Group(s)
-
Group By Supplier & Range
-
Yes / No
-
-
Measured Goods with a specific with or all widths
-
Product Group
-
Mode
-
Summary / Detailed with Options / Detailed without Options
-
-
Show Origin
-
Yes / No
-
This option will show the origin of the stock, i.e., the Write-on note or GRN number.
Print Sequence
As indicated by blue numbered squares in the report example.
1 Location
2 Supplier / Vendor (if selected)
3 Range / Collection (if selected)
4 Product Group or Supplier
5 Sales Order
6 Stock ID
Report Totals
As indicated by yellow numbered squares in the report example.
1 Matrix Totals - Supplier / Product Group or Report dependent upon choice
2 Report
Printed Fields
Fields printed on the report.
-
Selling Location
-
Supplier / Vendor (where selected)
-
Range / Collection (where selected)
-
Product Group Code & Description
-
Quantity Sold
-
Percentage of Total
-
Line Selling Value
-
Percentage of Total
Detailed Mode
-
Sales Order Number
-
Stock Detail ID
-
SKU
-
Product Description
-
Product Options (where selected)
-
Quantity Sold
-
Unit Price
-
Origin (GRN / Write-On Number) - where selected
Detail fields are shown in blue italic text.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article