Display First Value Only

[datalink]

On an order acknowledgment document that is based on an order line items table and constructed using a list view with headers etc., we are being asked to have one particular field display in the body part only on the first occurrence of the a piece of data. So the first record would display X in that field and in the list view nothing would display in that field for subsequent records until a new value appears. The list is sorted by that particular field and the logical way to do this would be to display in a leading sub summary part, however they are being very specific that they want it displayed in the body data. (They are trying to replicate their previous document set and feel that it is important that the new Filemaker based documents match the documents that they have been using in previous years.)

First attempt was a calculation field that used a case statement and GetNthRecord to test the pervious record for a matching value and display or not based on a match.

Case(GetNthRecord(oli.SSJ_SKUSeasonJoin::LookBookPageNumber ; Get(RecordNumber) - 1) = oli.SSJ_SKUSeasonJoin::LookBookPageNumber ; "" ; oli.SSJ_SKUSeasonJoin::LookBookPageNumber)

However, that only works for one record back. I need something that is more dynamically extensible. Any suggestions?

[LaRetta]

Hi Datalink!

Conditional formatting should work nicely here. Select that field and it formula would be:

oli.SSJ_SKUSeasonJoin::LookBookPageNumber = GetNthRecord ( oli.SSJ_SKUSeasonJoin::LookBookPageNumber ; Get ( RecordNumber ) - 1 )

... then below select More Options and set the font size to custom and 500. This will make the value disappear if it is the same as the previous record. This is assuming that the LookBookPageNumber field is included in the sort as the last sort item, although it does not need to be - it will work regardless. :^)

Edited May 14, 2012 by LaRetta