Search results for query: *

Thanks Pete. Your code looks like it will work. To understand your code I have a question. Is the OnFirstRecord and OnLastRecord being executed for each client group? The Crystal Help file says OnFirstRecord Returns TRUE when the current record being evaluated is the first record in the...

Hello Crystal Experts, Here is my puzzle: I need to create a hospital report of client movements, but the report must only display the first record, that is the earliest movement date, of the client's latest Unit location. The records are sorted by client ID and movement date with movement...

Thanks for your help! Joe

Hello, I need the code to extract the first word in a string. For some records, the the generic drug name name will only have one word, sometimes more than one word. In both scenarios I need to the code to extract the first word. Example: OLANZAPINE OLANZAPINE PAMOATE The output of both...