Notifications
Clear all
Topic starter
Looking for some guidance on formulating the Section Expert to suppress duplicate results. I had this in the past, but cannot locate it when I need it--typical. 
If I remember right, it looked at the previous line results and checked if it equaled the next line's, then either suppressed or displayed accordingly.
Thanks in advance,
Sam
Posted : December 27, 2012 6:04 am
Could you use a DISTINCT clause in your query? Or in CR, from the Database drop down, select distinct records?
Posted : December 31, 2012 1:51 am
Topic starter
Sorry, I didn't word that above post correctly.
I'm trying to suppress additional results and only get the first/last in the series. For example:
BEFORE:
Patient 1, Lab 1 Result
10/2012 10.0
11/2012 11.8
12/2012 9.7
AFTER:
Patient 1, Lab 1 Result
12/2012 9.7
Posted : January 2, 2013 3:53 am
group by patient, sort by date, put fields in group footer, will show last in footer.
Posted : January 2, 2013 4:02 am
Topic starter
Thank you!!!
Posted : January 2, 2013 4:26 am
