Print Page | Close Window

Field count chancing after adding new field

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19485
Printed Date: 04 May 2024 at 8:51am


Topic: Field count chancing after adding new field
Posted By: brreid
Subject: Field count chancing after adding new field
Date Posted: 01 May 2013 at 9:52am
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.



-------------
Thanks for sharing the knowledge



Print Page | Close Window