I am writing a report that I cannot figure out. Here's what I'm working with.
Crystal Reports XI. I've got two tables involved.
Patient_Demo can have many Ext_Pat_IDS.
What I need is this. I can only show each patient once. IF they have an ID in Field1, use that, if not, use ID in Field2, etc. As it stands right now, I've jumped from having a result set of 2450 records to 4991 just by adding the ID to the report. I need it to remain at 2450, and only show the patient using the most primary ID.