Is there a way to get a list of users that have clicked cancel? but have not expired yet? Also is there a way to get users that have expired and have not renewed I noticed when I do a search for expired users... I get people that have already re-renewed. Am I using the search wrong? Thanks
No there is no such report. And this can't be done via SQL query, custom php script will be required. In regards to search it search for payments, not users. Try to use filters at aMember CP -> Browse users