I have Crystal Reports 8.5
I am building a report over a Doctor Database in Lotus Notes. Each Doctor has a Department field which contains only one department. Each Doctor has a Specialty field that is free form and can contain more than one specialty. i.e.
Doctor Name Department Specialty
Dr. Aabba Anesthesia Anesthesiology
Dr. Babba Anesthesia Anesthesiology,Pain Mngmt.
Dr. Cabba Family Pract. Familty Pract.
Dr. Dabba Family Pract. Geriatrics,Family Pract.
I am trying to build a drill down report that shows the following:
Anesthesia 3
Anesthesiology 2
Dr. Aabba
Dr. Babba
Pain Mngmt 1
Dr. Babba
Family Pract. 3
Family Pract. 2
Dr. Cabba
Dr. Dabba
Geriatrics 1
Dr. Dabba
TOTALS 6
Yes, I know that this means that some of my Doctors get counted more than once but this is the way my users want it. I am trying to avoid using Crystal SQL Designer and Crystal Dictionaries as this report will be going out to Crystal Enterprise. I also have access to Crystal 9.0 through a collegue, if using this would be easier. I have figured out how to get all of my specialties into one large array, through the use of a subreport, but I am not sure if this is the way I should go or not. Any help is greatly appreciated. Thanks.
I am building a report over a Doctor Database in Lotus Notes. Each Doctor has a Department field which contains only one department. Each Doctor has a Specialty field that is free form and can contain more than one specialty. i.e.
Doctor Name Department Specialty
Dr. Aabba Anesthesia Anesthesiology
Dr. Babba Anesthesia Anesthesiology,Pain Mngmt.
Dr. Cabba Family Pract. Familty Pract.
Dr. Dabba Family Pract. Geriatrics,Family Pract.
I am trying to build a drill down report that shows the following:
Anesthesia 3
Anesthesiology 2
Dr. Aabba
Dr. Babba
Pain Mngmt 1
Dr. Babba
Family Pract. 3
Family Pract. 2
Dr. Cabba
Dr. Dabba
Geriatrics 1
Dr. Dabba
TOTALS 6
Yes, I know that this means that some of my Doctors get counted more than once but this is the way my users want it. I am trying to avoid using Crystal SQL Designer and Crystal Dictionaries as this report will be going out to Crystal Enterprise. I also have access to Crystal 9.0 through a collegue, if using this would be easier. I have figured out how to get all of my specialties into one large array, through the use of a subreport, but I am not sure if this is the way I should go or not. Any help is greatly appreciated. Thanks.