I'm grouping data by major product groups based on UDF_PRODUCT_CODE. I want all ungrouped Product_Code's to return "Others"
I've used Default: "OTHERS" but the report is still showing blanks. Anybody know why?
Here's my code (in Crystal Syntax):
Select {AR_InvoiceHistoryHeader.UDF_PRODUCT_CODE}
Case "BENCH MART SR", "BENCH MART DELUXE", "BENCH MART PLAIN":
"RETAIL"
Case "MISCELLANEOUS", "SPORTING GOODS", "VINYL":
"MISCELLANEOUS"
Case "XA-210", "XA-300", "FIELD PRO", "PT - SERIES", "SF-23":
"COMMERCIAL"
Case "W TRUSS", "SUN STOPPER", "SUN SHADOW":
"SHADE STRUCTURE"
Case "HOBBY ACCESSORIES":
"HOBBY"
Case "FENCE- ON- A- BENCH":
"DISPLAYS"
Default:
"OTHERS";