In my ReportHeader there are a number of Fields that read from a SQL query. It works fine, as most of the fields are provided in the first row.
However there is a Field that require a condition in finding the right row. e.g.
CompanyName OfficeLocation Name Phone EmployeeType
ABC Ontario Tom 123 Contract
ABC Ontario Ann 234 Full
ABC Ontario May 456 Boss
Company Name: [=Fields.CompanyName]
Office : [=Fields.OfficeLocation]
Boss: [=Fields.Name] (Wont work, as it will display Tom and not May since Tom is the first row)
So how do I make it so it will display May in the Boss Field?