CiviCRM Community Forums (archive)

Hi there,

We have a client who has a common workflow of wanting to be able to report on contributions that were made by contacts in a certain postcode. The standard Contribution Details report gives this functionality, however the postcode filter field is set as looking for an integer. I am presuming this is because US postcodes are integer values. Unfortunately this does not work with UK postcodes which are a combination of letters and numbers, since the operators being used are looking for an integer value (i.e. they are looking for equal to, greater than etc).

Has anyone come across this before?
Is there any thoughts of amending this report to consider UK postcodes? (an IS LIKE operator would work fine!)

I know there is a work around of searching for people in a certain postcode and then running the report on that group but it just makes the workflow a bit clunky and long-winded.

Many thanks,
Maya