I am working with a report using Crystal Reports v9 from an SQL database.
I have two tables:
One is a care_map table. The other is a staff_table.
The care map table includes a key for the particular care map. Also included is a staff_id. There may be multiple staff_id’s for a given care map.
The staff table includes the staff_id and the name of the staff person.
What I need to be able to do is to develop a formula or some variable that will include in one text string all of the names of all staff who are associated with a particular care map key.
The count of staff associated with any given care map key will vary.
For example:
For Care map key 10, there may be 3 staff (Jane Doe, John Doe, Mary Doe)
Right now, I can list these individually in a details section. But what I need to do is to be able to develop one variable with one string that will include all the names (ie: Jane Doe, John Doe, Mary Doe).
This variable then can be used to replace a placeholder variable in a memo field in the group header.
Any suggestions.
Pudge
I have two tables:
One is a care_map table. The other is a staff_table.
The care map table includes a key for the particular care map. Also included is a staff_id. There may be multiple staff_id’s for a given care map.
The staff table includes the staff_id and the name of the staff person.
What I need to be able to do is to develop a formula or some variable that will include in one text string all of the names of all staff who are associated with a particular care map key.
The count of staff associated with any given care map key will vary.
For example:
For Care map key 10, there may be 3 staff (Jane Doe, John Doe, Mary Doe)
Right now, I can list these individually in a details section. But what I need to do is to be able to develop one variable with one string that will include all the names (ie: Jane Doe, John Doe, Mary Doe).
This variable then can be used to replace a placeholder variable in a memo field in the group header.
Any suggestions.
Pudge
