Cetin,
Thanks for the additional info. I was able to reproduce it (the issue of count-1), so I'll address it. Thanks.
I think you'd agree that bringing down 100,000 rows from the back-end is a high amount and maybe not necessary. However, I bumped it from 1,000 rows to 100,000 rows. Yes, filters will take longer, but I didn't have to wait 35 minutes. There is the option (checkedbox list) to scope the filter to only certain columns.
The issue with rowfilter is that it's not applicable to columns that are coming from parent tables. But I will certainly look into this to see if there's something that can be done to improve it.
Thanks for your input!
Kevin