fragglemoo
IS-IT--Management
CR2008
I have a report that is grouped and one of the fields is a date/time field. The values in this field should all be the same but occasionally they are incorrect and I want to highlight these in red. I have been able to partially do this using
If ({Command.Promotion to Production}) <> Previous (({Command.Promotion to Production}))
Then
red
else if
({Command.Promotion to Production}) = (({Command.Promotion to Production})) then black
However this ignores the fact that the report is grouped and produces.
Group1
16/8/08
16/8/08
16/9/08
Group2
28/8/08
How do I do this by group?
Thanks.
I have a report that is grouped and one of the fields is a date/time field. The values in this field should all be the same but occasionally they are incorrect and I want to highlight these in red. I have been able to partially do this using
If ({Command.Promotion to Production}) <> Previous (({Command.Promotion to Production}))
Then
red
else if
({Command.Promotion to Production}) = (({Command.Promotion to Production})) then black
However this ignores the fact that the report is grouped and produces.
Group1
16/8/08
16/8/08
16/9/08
Group2
28/8/08
How do I do this by group?
Thanks.