Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 BackgroundColor expression

Author  Topic 

dave.bodenheimer
Starting Member

5 Posts

Posted - 2013-05-06 : 18:03:45
I'm trying to alternate the background color of a group header row. I'm using the expression
IIf(BackgroundColor = "#244b5c" , "#b5c7d3", "#244b5c")

I'm getting an error. I believe this is becase the term BackgroundColor in the IFF is incorrect. How do you refer to the header row?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-07 : 00:43:52
use Inscope

IIF (Inscope("GroupName"), "#b5c7d3", "#244b5c")


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -