I have a table containing postcodes and their X and Y coordinate location. I am trying to run a query whereby I select one postcode which then selects all the postcodes that lie within a selected radius of this point. However anything I try seems to keep leading me up a blind alley. Does anyone know if this type of query is possible in Crystal Reports?
Yes, that's correct.
You're picking it up quickly.
I suggest you look at:
-adding sub sections to sections (Group Footer 1, Group Footer 1a, etc)
Place whatever formula you have in a section and actually see when it is evaluated.
This will tell you it's ok to place the next formula in the same section or one below it.
This is tricky, so it takes a little experimentation and patience.
Hope this helps,