Formula for Fill Color of Box Object Works Locally, Not on Server

[Former Member]

Hello all!

I've exhausted all attempts to reconcile this issue I'm experiencing, and couldn't find a similar issue through Googling. I have the following formula for a box object's fill color in a group header:

select {Entity.Color}

case "red" : color(255, 0, 0)

case "orange" : color(255, 165, 0)

case "yellow" : color(255, 255, 0)

case "blue" : color(95, 158, 160)

case "green" : color(0, 128, 0)

case "blue" : color(173, 216, 230)

case "Violet" : color(238, 130, 238)

case "gray" : color(128, 128, 128)

case "olive" : color(128, 128, 0)

case "black" : color(0, 0, 0)

When I run the report locally, the coloring behaves as expected, with the correct color displaying based on the Entity's color property. When I deploy the website application to our test server, the color no longer displays and it defaults to the white fill color in the Box Object's properties. Any ideas? I've tried executing the report on the server through different browsers, changing color to rgb, and a few other things. This is for an ASP.NET 4.5 MVC Web Application.

Any help is greatly appreciated!

[former_member11696 · Accepted solution]

Oops, Box Objects do not have that feature... Try adding a box around the object using the Border Feature....

Try this, since you never said how you are formatting the object:

Click the X+2 button and notice the color values are CR defined:

// This conditional formatting formula must return one of the following Color Constants:

//

// Color (red, green, blue)

// crBlack

// crMaroon

// crGreen

// crOlive

// crNavy

// crPurple

// crTeal

// crSilver

// crRed

// crLime

// crYellow

// crBlue

// crFuchsia

// crAqua

// crWhite

// crNoColor

//

If "combined_vmi_vendor_activity.VMI_TYPE"<>"BEG_BAL" then crRed

else

If .....

Don