I am very new to Crystal. I have searched the Internet extensively and I am unable to find a solution that I can get to work.
I have a report that has a group for each client. A client can have many episodes and each episode can have up to 3 diagnosis'. I only want to display the detailed section for the group where the diagnosis' do not match. I have appended the fields of date of diagnosis along with the 3 diagnosis in order to get one field for comparison. The output without the restriction of removing groups where the diagnosis is the same looks like what I placed in the attached file. What I want to achieve with the data in the file is to see only Groups with PATID = 145 and 51994. Any suggestions?
I have a report that has a group for each client. A client can have many episodes and each episode can have up to 3 diagnosis'. I only want to display the detailed section for the group where the diagnosis' do not match. I have appended the fields of date of diagnosis along with the 3 diagnosis in order to get one field for comparison. The output without the restriction of removing groups where the diagnosis is the same looks like what I placed in the attached file. What I want to achieve with the data in the file is to see only Groups with PATID = 145 and 51994. Any suggestions?