Crystal Reports Field count changing after adding new field

Message

   Hi 

I am trying to run a report on number of patients who had their BMI checked during last month. (250 patients was seen) how many of them had their BMI checked and how many didn't. When I add the first field which is the patient ID it returns 250 patients but when I add the BMI field the patient ID count changes to 175, I would like to see the 250 patient ID with and without the BMI%

what am I doing wrong?

I am pulling the data from three different Excel cheets. and I'm using Crystal X1

Here is what I would like my report to look like:

Patient ID:   BMI%

2222222        25.02

3333333        32.00

4444444

5555555        40.00

But  here is what I'm getting:

Patient ID:   BMI%

2222222        25.02

3333333        32.00

5555555        40.00

Thanks for your help.

Edited by brreid - 01 May 2013 at 9:54am