Report Problems

cunningham93

Registered User.
Local time
Today, 06:02
Joined
Mar 17, 2014
Messages
13
I am hoping that someone can help me with my report. I have attached a PDF copy for review. Currently my report is grouped by Judge, then Treatment Center, then Treatment Type. and it does generally look at it should but does not indicate the values in an easy to understand way. I would like it be laid out as follows in columns:

Judge (number of clients assign) Treatment Center (number of clients assign), Treatment Type (number next of next to each treatment type), Sex (number of male, number of female) Drug of Choice "DOC" (number of next to each type of drug) Discharge Type (number of next to each type).

I have tried to rework my query and the report several time to make this happen with no success. Currently, my query gathers all of the clients who have a record on the inpatient treatment table, grouped by and with totals. I am open any and all suggestions. Thank you in advance for your assistance.
 

Attachments

Users who are viewing this thread

Back
Top Bottom