Transparent Background Color in SSRS Textbox

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Knight » Transparent Background Color in SSRS Textbox

Transparent Background Color in SSRS Textbox

Rate Topic

Display Mode

Topic Options

Author

Message

pollyjeanherr

Posted Thursday, April 15, 2010 12:03 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 22, 2011 11:11 AM
Points: 2, Visits: 4

I get a warning similar to this:
[rsInvalidColor] The value of the BackgroundColor property for the textbox ‘textbox22’ is “Transparent”, which is not a valid BackgroundColor.
every time I use "Transparent" as a color in the conditional expression for BackgroundColor.
Why does this happen? The reports seem to work regardless. In newer reports I am using "White" in similar circumstances, but since "Transparent" is the default BackgroundColor why does it generate an error?

Post #904282

w.plymesser

Posted Wednesday, January 11, 2012 1:24 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 4:22 PM
Points: 75, Visits: 193

I know this post is over a year old, but the same error has got me puzzled.

I'm using SSRS 2008.

I also get this error when using "No Color" in a conditional expression. That's what the property value is set to when first opened. I've got two textboxes, and I set each one to use each (non)color.

[rsInvalidColor] The value of the BackgroundColor property for the text box ‘Textbox57’ is “No Color”, which is not a valid BackgroundColor.
[rsInvalidColor] The value of the BackgroundColor property for the text box ‘Textbox58’ is “Transparent”, which is not a valid BackgroundColor.

Here's the expression I'm using:

=iif(Parameters!RptGrouping.Value="Region",iif(Fields!Grp1.Value<>" ","Transparent","LightGrey"),"Transparent")

Basically, if the report is at a Regional level, I want to color the text box Light Grey if the Grp1 field is populated. It works, even with the error. Is this one of those times where I ignore it and move on?

Post #1234333

w.plymesser

Posted Wednesday, January 11, 2012 1:40 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 4:22 PM
Points: 75, Visits: 193

I changed one little search parameter after posting the problem, and found the answer.

Instead of "No Color" or "Transparent", I used "#FFFFFF", and it works flawlessly.

Found at http://www.johnstagich.com/Blog/post/September-2010-Quick-Hits.aspx.

Post #1234344

mark 4643

Posted Wednesday, August 15, 2012 7:15 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:29 AM
Points: 24, Visits: 75

w.plymesser (1/11/2012)

of couse it does FFFFFF is white. That is NOT transparent

Post #1345258

Oliiii

Posted Wednesday, September 05, 2012 1:35 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:21 AM
Points: 194, Visits: 684

Set the color to Nothing and it works:

=Iif(Fields!InstanceBlackout.Value = 1, "Orange", Nothing)

Found the answer here.

Post #1354354

« Prev Topic | Next Topic »

Permissions