Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Radius Calculation

Hi

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?

Former Member
Former Member replied

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)

-shared variables

-WhilePrintingRecords

-BeforePringtingRecords

-EvaluateAfter

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,

The Panda

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question