Hi
I have a report that shows clients who were served by a group of 12 specific hospitals who had one medical visit in the past year in that hospital. The report gives the client ID, the type of medical misit and the visit date and groups the data by Hospital.
I them want to match those clients on their unique client identifier (the identifier is NOT hospital dependent) to see if they were served by any hospital other than the original 12 hospitals. This part of the report should show me the name of each of the other hospitals the client visited, the date of the visit and the visit type. Would this need to be done by a sub report? If so how might I do it.
I have a report that shows clients who were served by a group of 12 specific hospitals who had one medical visit in the past year in that hospital. The report gives the client ID, the type of medical misit and the visit date and groups the data by Hospital.
I them want to match those clients on their unique client identifier (the identifier is NOT hospital dependent) to see if they were served by any hospital other than the original 12 hospitals. This part of the report should show me the name of each of the other hospitals the client visited, the date of the visit and the visit type. Would this need to be done by a sub report? If so how might I do it.