conditional format of row data value
conditional format of row data value
(OP)
I am using CR 2016
How can I make a field at record level change font colour if its value has changed from previous row value( in detail level) I should also say its ONLY the change in a detail row with any groupings I have
eg
y
1
1
1
1
2 - to show red fornt
2
x
1
1
ie row value - last row value (within group) not equal zero then highlighlight
How can I make a field at record level change font colour if its value has changed from previous row value( in detail level) I should also say its ONLY the change in a detail row with any groupings I have
eg
y
1
1
1
1
2 - to show red fornt
2
x
1
1
ie row value - last row value (within group) not equal zero then highlighlight
RE: conditional format of row data value
RE: conditional format of row data value
RE: conditional format of row data value
Thus at the Group Header (GH)
Shared numbervar somevar := {fieldvalue};
At the detail level in the font tab for the field
Shared numbervar somevar;
if somevar <> {fieldvalue} then crRed else crBlack
Code not tested, but pretty sure it will work.
RE: conditional format of row data value
RE: conditional format of row data value
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: conditional format of row data value
{table.field}<>previous({table.field}) and
{table.groupfield}=previous({table.groupfield}) then
CrRed else
CrNocolor
-LB
RE: conditional format of row data value
Thanks
PS - SVought - er Excel is NOT an option or auditable! :)
RE: conditional format of row data value
-LB