Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Select Case Default incorrectly returns blank Post Reply Post New Topic
Author Message
atminnie
Newbie
Newbie


Joined: 19 Jul 2010
Online Status: Offline
Posts: 9
Quote atminnie Replybullet Topic: Select Case Default incorrectly returns blank
     Posted: 30 Sep 2010 at 8:50am
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";

IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum