conditional formatting with icons

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)

conditional formatting with icons

Author

Topic

HenryFulmer
Posting Yak Master

110 Posts

Posted - 2012-10-15 : 17:00:57

Can I add conditinal formatting to my report fields such as in Excel where it is possible to add up and down arrows based on the cell value?
I know I can adjust cell colors by my report requirement caalls for arrow performance indicators?
any help would be appreciated.


=switch(Fields!mydata.Value = 1,"blue",
Fields!mydata.Value = 2,"green",
Fields!mydata.Value = 3,"orange",
Fields!mydata.Value = 4,"red")

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-10-15 : 17:39:11

You can specify Unicode characters ? (U+2191) and ? (U+2193) in a switch function for the field expression (not the color expression).

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-10-15 : 22:59:56

From SSRS 2008 R2 you have this feature available in the tool known as indicators

http://technet.microsoft.com/en-us/library/ee633651(v=sql.105).aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources