Variable in Crystal XI

[Lightbug3]

Hi All!

I am creating a report that lists every prescription a person is taking and the "Disease State" it is in. In the Group Header I need to list all the Disease States that this person is taking a prescription for. However, I cannot figure out how to do it.

In the details section, I have a formula for disease state. The person can be taking prescriptions for the same disease states. Therefore, the detail section could look like:
Diabetes
Diabetes
CHF
Diabetes

In the Group Header I need to output:
Diabetes, CHF

Does anyone know how to do this?
Thanks.
Danielle

 

[Turkbear]

Hi,
What database?

What is the table structure..Is there a separate entry for each patient/prescription/disease combination?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Lightbug3]

Yes. There is a separate entry for each prescription/patient. My report is grouped by patient as well. Each patient gets one letter with all their prescriptions.

 

[ShortyA]

If your "Patient" grouping is "Group1" could the "Disease State" be "Group2" ie add it in as a group and then perhap suppress the detail section unless you really need it.

Your output would then look like:

Mr Patient 1
- Diabetes
- CHF

Hope this helps.
ShortyA