I am attempting to create a report that looks as so:
Client Name Date of Service Screened for Trial Trial Available Trial Offered
Jane Doe 1/1/2013 Yes
Jane Doe 1/1/2013 Yes
Jane Doe 1/1/2013 No
John Smith 2/1/2013 Yes
John Smith 2/1/2013 No
John Smith 2/1/2013 No
And I have changed it to the following using the group footer and the min/max values of each column with a sort on Client Name.
Client Name Date of Service Screened for Trial Trial Available Trial Offered
Jane Doe 1/1/2013 Yes Yes Yes
John Smith 2/1/2013 Yes No No
However
I am receiving this issue:
For the trial available column, if the client was seen multiple times and had the trial offered and then at a different date they were denied a trial. This is causing the columns to overlap.
Client Name Date of Service Screened for Trial Trial Available Trial Offered
Jane Doe 1/1/2013 Yes Yes
Jane Doe 5/1/2013 Yes No
In this case, the Yes and no would overlap each other and only one of the dates of service would show up. Is there a way to have it be listed as follows:
Client Name Date of Service Screened for Trial Trial Available Trial Offered
Jane Doe 1/1/2013 Yes Yes
5/1/2013 Yes No
IP Logged
