Group Name even if detail is blank

[kinvie]

I am using Crystal Reports 10.0 to connect to our electronic medical record with an ODBC connection. I have a report that lists patients and the specific labs, the lab values and the date they have been done for certain diagnoses. The problem is that if a patient has never had the lab test done then, the name of the group does not appear under the patient name. The physicians would like to see a blank if the patient had not had the test done.

Currently, my report would display:
Patient Name (Group 1)
LDL (group 2) 99 1/1/2007
HGBA1C (Group 2) 12.1 1/1/2007

What I would like it to display would be, even though the patient has not had the eye exam.
Patient Name (Group 1)
LDL (group 2) 99 1/1/2007
EYE Exam (group 2)
HGBA1C (Group 2) 12.1 1/1/2007


Is there a way for me to get what I really want, the group name to print even if the patient does not have it as a record?
Thanks in advance for your help.

 

[dgillz]

Crystal does not report on data that does not exist in the report.

So you will need to take the table that includes all types of possible services performed (Group2) values, regardless if they were performed in the recordset you are working with. Left outer join this table to the table of the services performed table, rather than just reporting on the services performed, and group on this field.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet