Hi, I have a report grouped by name, I have a column called status. Is there a way to highlight the first row that status is NULL for each group using conditional formatting?
Thanks.
Fen
Probably if you can write an expression that is true when that condition is true. You'll need to identify a field that defines the sort to be able to know what's first. Either an aggregate function like DCount or a subquery would probably be the way to go. If you can upload your database so that I can see the details I'll see if I can come up with the expression. If you can't upload the database then post the record source SQL of the report and tell us which field defines the sort and which defines the grouping