jspc
asked on
Crystal Report to Group Product Code
Hello,
I have the attached Stock Qty Sold Product Report.
I am wanting to be able to GROUP the Product Code ('parent') together so it doesn't show it's 'child' entry and have a drill down feature.
When I run the report with a product code like:
1001.01.00
1001.02.00
I want to be able to group it so its:
1001
RPT file uploaded is saved with data.
GroupReport.png
12MonthProductSalesUnits.rpt
I have the attached Stock Qty Sold Product Report.
I am wanting to be able to GROUP the Product Code ('parent') together so it doesn't show it's 'child' entry and have a drill down feature.
When I run the report with a product code like:
1001.01.00
1001.02.00
I want to be able to group it so its:
1001
RPT file uploaded is saved with data.
GroupReport.png
12MonthProductSalesUnits.rpt
ASKER
Hello, I have created the formula, but am having trouble grouping to, to make it work. Can you help please?
I have attached the file if needed.
12MonthProductSalesUnitsBy-Group.rpt
I have attached the file if needed.
12MonthProductSalesUnitsBy-Group.rpt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
Split({Product Field},'.')[1]
Group on that field then group on the product field
Hide the product field group and details so you can drill in
mlmcc