Can you not drop this data down using the Import/Export wizard (https://pos.citruslime.com/backofficeux/importexports.aspx) and then work on it in Excel?

It'll be way faster than waiting for Cloud Reports to do anything. You could then also tidy up the database, move all numbers into the mobile field, capitalise names, correct postcode formatting etc..

I did this to our customer database a couple of years ago. I had to re-import the edited files in batches of 999 though as Citrus couldn't handle anything bigger.

I recently also looked for an overview of all customers. In the current case, I searched by postal code and in a second evaluation by birth dates. It would be nice to have all the data available as a report in the cloud reports.

landline is a dated field that has proven to get in the way, only last year the webiste was putting the customers mobile number in the landline field and the solution was to put the mobile in both fields so i susspect the landline field is hard coded in somwhere and hard to get rid of