Skip to Content
avatar image
Former Member

EVDRE FORMAT: EVALUATE IN

Dear all,

In my EVDRE report, the "evaluate in" doesn't work properly:

KEY="TAXES"

Evaluate in = ALL

format: yellow

apply to: key

-> it's not applying the format in the row key range

KEY="TAXES"

Evaluate in = ROW

format: yellow

apply to: key

-> it's applying the format in the row key range

Why it doesn't work in the first case? ALL means: OR ROW OR COLUMN OR PAGE OR CELL...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 24, 2010 at 09:54 AM

    Hi,

    I would say that there is probably another line in your Format Range that overrides the COLUMN formatting.

    The sequence of format is applied in the order you define in the FormatRange table.

    Hope this will help.

    Best Regards,

    Patrick

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Patrick Favre

      Hi,

      That solution works fine!

      So best practice is not to use the KEY syntax in this case...

      Thanks!

      Dietrich

      Edited by: dfries on Jun 24, 2010 5:16 PM