Crystal Reports Need help with trying to use formuls in section ex

Message

     Hi All,

I am trying to use a formula to select only patients that have diabetes. After that if they have HGBA1C/HGBA1C%POC values then I want those values displayed else if its null value then just a blank space. But I want all patients with diabetes displayed. Somehow my formula is not working the way I want it to (its written below, the part I wrote is in bold). PLEASE PLEASE PLEASE help!!

{PERSON.PSTATUS} = "A" and

{PROBLEM.CODE} in ["1ICD-250.1", "ICD-250", "ICD-250.0", "ICD-250.00", "ICD-250.01", "ICD-250.02", "ICD-250.03", "ICD-250.10", "ICD-250.11", "ICD-250.12", "ICD-250.13", "ICD-250.2", "ICD-250.20", "ICD-250.21", "ICD-250.22", "ICD-250.23", "ICD-250.3", "ICD-250.30", "ICD-250.31", "ICD-250.32", "ICD-250.33", "ICD-250.4", "ICD-250.40", "ICD-250.41", "ICD-250.42", "ICD-250.43", "ICD-250.5", "ICD-250.50", "ICD-250.51", "ICD-250.52", "ICD-250.53", "ICD-250.6", "ICD-250.60", "ICD-250.61", "ICD-250.62", "ICD-250.63", "ICD-250.7", "ICD-250.70", "ICD-250.71", "ICD-250.72", "ICD-250.73", "ICD-250.8", "ICD-250.80", "ICD-250.81", "ICD-250.82", "ICD-250.83", "ICD-250.9", "ICD-250.90", "ICD-250.91", "ICD-250.92", "ICD-250.93"] and

not ({PERSON.SEARCHNAME} startswith "<MRG>") and 

If ({OBSHEAD.NAME} like ["*HGBA1C", "*HGBA1C%POC"]) then ["*HGBA1C", "*HGBA1C%POC"]else if isnull {OBSHEAD.NAME} then " "

Edited by saumyarpandey - 29 Apr 2013 at 9:15am