Hi All, I have a requirement to colour code every second (Detail)line of a sub report based on the charge point and Labour Line of an invoice.
The charge points could be "customer"(Coded Blue), "internal" (Coded Green)or "warranty" (Coded RED).
The invoice can contain "parts" (MAG),"Labour" (TMP) and "descriptions"(DES).
The invoice in the core product can be assembled randomly, depending on what line the user puts on first and differs each time.

Below is a sample of the data.
Product                      Description        ID     Charge      
Job 1                                                 GRP          
95557533310           AIR DUCT LATER MAG     CST      
95510717600           GASKET OIL      MAG     CST      
1                                 Labour          TMP     CST      
1                                 Labour          TMP     CST      
                               FIX ALL THNGS   DES           
4320765                  ADHESIVE FILM   MAG     WAR      
1            LABOUR - check lights           TMP     CST      
1          LABOUR - check brakes           TMP     INT

what I am trying to achieve is to get a "True" or "False" response in a group header, based on the FIRST Labour (TMP) line..
EG: in the example above line 4 is the first Labour Line has an ID of TMP and a Charge of CST therefore would return "True".
if the first Labour line had an ID of TMP and a Charge of INT the result would be "False".

Any help on this formula would be gratefully appreciated.

Regards Wayne            

Edited by crwzar80 - 27 May 2014 at 2:18pm