Thursday, February 19, 2009

Conditional Formatting in Ticker View

Completing this requirement was real fun. Conditional Formatting is not visible in Ticker View as we can see it in Table or Pivot Table. To make it work we just need to insert some HTML tags in column formula. The procedure is given below.

Include columns in the Request Criteria and apply appropriate Filters.


Create New Ticker View of the report.

Beginning: <table>

Row Format: @1 - @2, @3, @4, @5

Row Separator : <br><br>

Ending Text: </table>

Now suppose we need to show "Account Name" in purple (#7030A0) when Lives > 50000.

Go Back to Criteria, click on Column Properties of "Account Name" and set the Data Format as HTML.


Change the Column Formula of Account Name to show the HTML tags when Lives >50000

i.e. Change the Column Formula of Account Name to :

case WHEN "Opty - Sales".Lives > 50000 THEN '<font color = #7030A0><b>' ¦¦ Account."Account Name" ¦¦'</font></b>' ELSE Account."Account Name" END



I cant publish the report snapshot, however the above process will result in required output