Using Count as a filter basis
Posted: Tue Oct 12, 2010 8:28 am
I'm working on a report that lists land parcels that are in multiple tax districts. I have it grouped by parcel number, and I need to display ONLY the parcels that have more than one record (multiple tax districts). If a parcel has a count of 1 I do not want it to display. If it has a count of 2 or more I do want it to display.
I tried a filter on the databand, but it does not work with string data (parcel numbers are string and can contain alpha and numeric characters). Is there a method to filter the dataset based on record count?
I tried a filter on the databand, but it does not work with string data (parcel numbers are string and can contain alpha and numeric characters). Is there a method to filter the dataset based on record count?