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
Using Count as a filter basis
Hello,
You can use conditions.
Please see the sample report in attachment.
Thank you.
You can use conditions.
Please see the sample report in attachment.
Thank you.
- Attachments
-
- 651.Sample Report.mrt
- (22.15 KiB) Downloaded 379 times
Using Count as a filter basis
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.
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
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.
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.