Conditional formatting with WAD

[Former Member]

Hi

We have a requirement to create a web report where we would need to:

• add conditional formatting based on result - compare two fields and set color based on result. e.g. if actual is better than target, the cell containing the actual must be made green

• add image based on result - compare two further fields (YTD act and target) and add an up arrow if the result is + and down arrow if -.

The result of these fields can be set in BEx using a formula, however, how do you format and call an image within a cell of a table based on the value in the cell?

[former_member189638]

Follow the steps to create the exception

First in your query create a Formula using a Boolean Operation.

(Actual > Target)

Since this is boolean, if this condition is satisfied it will always populate 1.

Now goto the Exception for the Key fig select your created formula

Click on New

Select the From Value and To Value as 1 and Alert level as Green

Transfer.

Save the query and execute

Your second requirement sounds a bit complex. If you are using WAD 3.5 then this could be achieved using Table Interface by creating a class in SE24 and dynamically populating the cells with the image.

Edited by: Rakesh Pattani on Jan 31, 2008 2:43 PM

[Former Member]

Hi Rakesh

Thank you very much for this helpful answer and pointing me in the right direction.

[former_member189638]

Your first requirement could be achieved creating exception in teh query itself.

[Former Member]

Hi

Thanks - i am in the process of testing your suggestion, any other suggestions on the rest of the question?

Thanks