I have a report that I only want to include the duplicate records for each matching MRN (reports is grouping on MRN).
Report currently looks like this
MRN Patient Name Acct No Adm Date
1159XX Uncle Sam 111 01/01/2016
1159XX Uncle Sam 222 01/02/2016
1159XX Uncle Sam 333 01/01/2016
1169XX Donald Duck 444 01/02/2016
1169XX Donald Duck 555 01/04/2016
1179XX Daisy Duck 666 01/03/2016
1179XX Daisy Duck 777 01/03/2016
I want it to look like this
MRN Patient Name AcctNo Adm Date
1159XX Uncle Sam 111 01/01/2016
1159XX Uncle Sam 333 01/01/2016
1179XX Daisy Duck 666 01/03/2016
1179XX Daisy Duck 777 01/03/2016