Page 1 of 1

Using Count as a filter basis

Posted: Tue Oct 12, 2010 8:28 am
by MikeC
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?

Using Count as a filter basis

Posted: Wed Oct 13, 2010 12:56 am
by Alex K.
Hello,

You can use conditions.
Please see the sample report in attachment.

Thank you.

Using Count as a filter basis

Posted: Wed Oct 13, 2010 9:30 am
by MikeC
Our reporting software is embedded into an application, therefore I can't download and view a stand alone report.

I looked at conditions, but my parcel numbers are strings and contain both alpha and numeric characters. When I attempt to write an expression to select parcel numbers with a count greater than 1 I get errors about trying to use count on string data.

Using Count as a filter basis

Posted: Thu Oct 14, 2010 1:24 am
by Alex K.
Hello,

CountData, which is calculated in the "After Print" event (CountData = Count (DataProducts);) counts the number of data and does not use the fields value, so it makes no difference whether there is a number or string.

Thank you.