You want to create a condition for font coloring.
In this case, right-click Date From detail field --> format field --> font tab --> create new formula on Font color

Here you want a different color everytime the location changes.

That is the same as saying "if the location in this record is not the same as the location in the previous record, then my record must have changed"

This relies on you sorting your data by location to work correctly (logically).

You can use a selection formula to accomplish that.
It'll basically be the same formula except written as a record selection formula. Instead of coloring the ones you want, you only show the ones you want.

Edited by Keikoku - 07 Apr 2011 at 3:50am

Oh.
Try this selection formula:

Oh.
Ok, then here's another option:

Open up section expert, and for the "suppress (no-drill down)" option create a formula that says

table.location <> previous({table.location})

It will then suppress all records where the locationis the same as the record before, showing only the first record that changed locations.



Edited by Keikoku - 07 Apr 2011 at 6:46am

A suppression formula does what its name suggests: suppresses items (which for some reason I had mixed up with selections)

The formula I wrote down should be

"table.location = previous(table.location)"

So it's saying "if it's the same as the one before, don't show it"

In your case, you're saying "if it's the same as the next one, don't show it". So if you think about it, it makes sense that you're getting the most recent change as opposed to the earliest change.

Edited by Keikoku - 08 Apr 2011 at 2:41am