Nice article. I do a lot of BI and KPI type reports and prefer to use a SWITCH statement on a flag instead of IIF statement:
=switch(Fields!mydata.Value = 1,"blue",
Fields!mydata.Value = 2,"green",
Fields!mydata.Value = 3,"orange",
Fields!mydata.Value = 4,"red")
Just an option I thought I'd share.
Frederick (Fred) J. Stemp, Jr.
Database Administrator / Database Developer
Dealer Funding, LLC
'...if they take my stapler then I'll set the building on fire...'