Page 1 of 1
Duplicates
Posted: Thu Feb 27, 2003 10:47 am
by mollybhc
What is the best way in dealing with duplicates? Many of my reports off our our Property Management Software contain many many lines of duplicates. I need more than the print once feature...If line 2 looks the exact same as line 1, I want to delete it...essentially cutting my reports in half. __Any help would be great!
=> RE: Duplicates
Posted: Thu Feb 27, 2003 1:29 pm
by Eddie_Marshall
What do you mean by duplicates excatly? Are you using scan type lookups? It sounds like you are. If so, I may be able to help. Maybe if you email your report it would be helpful. When debugging a report you need as much info as you can get!____Thanks.____Eddie Marshall__Technical Support Manager__LandMaster____eddie@landmaster.co.uk__http://www.landmaster.co.uk
==> RE: Duplicates
Posted: Fri Apr 09, 2004 11:20 am
by Chris_Strasser_(Guest)
My suggestion would be to use the PREVIOUS() function in a calculation in conjunction with line logic.____Example, a list of States, Counties and Metropolitan areas (STCD, CTCD, MTCD)____Create a calculated field, DUPE() to check if the current one is the same as the prior:____Previous(STCD) = STCD and Previous(CTCD) = CTCD and Previous(MTCD) = MTCD____Then put this onto the line logic for the band to print when FALSE. You^ll only see the distinct changes. Any number of fields can be placed into the calculation.