I have a report where i grouped on admission date and I am displaying in the details patien_id, patient_age, patient_admission_date, patient_admitting_practitioner, and program_value
This means that it will give me details on every progaram the client is opened to.
What i need at the end of my report is a count of clients whom are open to any program that starts with "drugalc" however i need all clients displayed even the ones not opened to "drugalc".
Basically i need a count of the clients opened to any program that starts with drugalc
suggestions?
hope this explains what i need well