Skip to Content
0
Former Member
Jan 10, 2012 at 09:50 PM

Crystal Reports capitalizes final s

23 Views

Hi,

Crystal Reports 2008. I have some data that is coming in "Medication already given due to patient?s clinical status"

Crystal Reports renders the word "patient?s " as "patient?S" (capital S).

In my SQL I tried coding

replace(sub2.alertResponseCode,'?S','''s') as alertResponseCode

It somes out fine in SQL, ""Medication already given due to patient's clinical status" but Crystal still renders it with that final capital S ""Medication already given due to patient'S clinical status".

Any ideas?

Thanks,

Dick