conditional format of row data value

mart10 · Nov 5, 2018

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

kray4660 · Nov 5, 2018

You could set up a formula in the field Format Editor (Font tab). Something like: if previous({someField}) <> {someField}) the crred else crblack.

mart10 · Nov 7, 2018

This doesn't quite work Im afraid It works across the rows within groups but as per my example above showing group y and group x I don't want it to do this across all rows just within the rows within each group

kray4660 · Nov 7, 2018

The other way is to set up formulas to capture the 'previous' value and then compare it to the current value, resetting on the group level.

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.

mart10 · Nov 9, 2018

sorry but that didnt work either in fact it was worse!

SkipVought · Nov 9, 2018

Use Excel instead.

Skip,
_{Just traded in my OLD subtlety...

for a NUance!}

lbass · Nov 9, 2018

If not onfirstrecord and
{table.field}<>previous({table.field}) and
{table.groupfield}=previous({table.groupfield}) then
CrRed else
CrNocolor

-LB

mart10 · Nov 19, 2018

Hi LB, you seem to know what to do but was bit confused on what you want me to do and where. Sorry to be a pain but could you elaborate

Thanks

PS - SVought - er Excel is NOT an option or auditable!

lbass · Nov 19, 2018

Use this formula in the format field->font color->x+2 formula area.

-LB

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

conditional format of row data value

mart10

MIS

kray4660

MIS

mart10

MIS

kray4660

MIS

mart10

MIS

SkipVought

Programmer

lbass

Technical User

mart10

MIS

lbass

Technical User

Similar threads

Part and Inventory Search

Sponsor