InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 09:26:51 GMT20http://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxWhat if I am calculating sum of values in a matrix and then based on the results would like to find out the max or min and not from the main select query itself ? I guess an example scenario will be useful , if Yes please let me know and I'll provide one...Wed, 12 May 2010 10:30:25 GMTsandipan.chandahttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxNo worries :) We can do this like this:1. In the properties of the column you want the color chnage to occur, go to Appearance | BackgroundColor and select the drop down &lt;Expression...&gt;. Then you'd do something like this for a Table:=swithch(isnothing(Fields!Width.Value) = 0, "transparent",Fields!Width.Value = &lt;your value/threshold&gt;, "green",Fields!Width.Value = &lt;your value/threshold&gt;, "yellow",Fields!Width.Value = &lt;your value/threshold&gt;, "red")You may not need a IsNothing statement but I provided one just in case your dataset does return NULL values. Now the Fields!Width.Value can use other aggregates like &lt;&gt;, &lt;, &gt; , =. You can also Use OR and AND statements if you want to set the condition to look at two different columns. You can also use IIF instead of SWITCH. My preference is SWITCH because nesting IIF statements can get confusing :)In a Matrix you should/may need to use an aggregate like SUM, AVG, MIN and so forth before Fields!Width.ValueI hope that is of some help. :) Let me know if I can help more!Thu, 25 Mar 2010 10:38:56 GMTFred Stemphttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxsorry, its confusing. The column value is for Width for a product. Like 12ft or 10ft or 8 ft. I want to change the font color propery of this.Thu, 25 Mar 2010 10:14:36 GMTstacey doranhttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxDoes the column's property allow it to auto grow? If not how are you setting the width property?Thu, 25 Mar 2010 10:06:30 GMTFred Stemphttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxI have a Width column. I need to change the format of the cells in the Width column.I would like the font to be Dark Blue if the Width value in the cell is different than the Width value in the cell in the previous row.Thu, 25 Mar 2010 09:28:47 GMTstacey doranhttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxWhat are you looking to do specifically?If it's from a cell and you want just that value to change format on another cell in the Expression of the cell you want changed you can reference the other cell by using ReportItems!&lt;cell name&gt;.ValueBut to really help, if you could provide an example of what you are trying to do, I maybe able to get you where you want to go :)Thu, 25 Mar 2010 09:10:54 GMTFred Stemphttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxany ideas on how to format a cell when the cell in the previous row has a different value.Thu, 25 Mar 2010 09:05:29 GMTstacey doranhttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxCan I have a conditional format of each "Person Name".For instant each person have got a set target, Then I want to format the "Sales YTD" to quickly see if the guys are achieving their target or not?Please assist guysThu, 20 Aug 2009 04:58:29 GMTpitso.macekehttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxNice 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.Tue, 19 May 2009 08:49:34 GMTFred Stemphttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxAnother Option would be to use the "Custom Code" area in the report properties to create a routine that would return a colour based on dollar value.This way you do not have to burden the SP with this display-ish logic.regardsMatteoFri, 15 May 2009 09:06:07 GMTMatteo-317581http://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxIf you despise the report designer as much as I do you could even take it a step further by returning the colour codes/names by the stored proc. This way you avoid those nasty IIF statements, and the logic is kept in one place:CASEWHEN SP.Bonus = @Topseller THEN '#0000FF' --BlueWHEN SP.Bonus = @Bottomseller THEN '#FF0000' --RedELSE '#000000' --BlackEND AS TopBottomSellerColour...or:CASEWHEN SP.Bonus = @Topseller THEN 'Blue'WHEN SP.Bonus = @Bottomseller THEN 'Red'ELSE 'Black'END AS TopBottomSellerColourThe 'Colour' property of the textbox could then simply be set to:=Fields!TopBottomSellerColour.ValueChrisWed, 06 May 2009 04:07:23 GMTChris Howarth-536003http://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxOops! Sorry about the typo - the ";" in the first snippet before CASE should, of course, be a comma!Tue, 05 May 2009 10:57:10 GMTAdam Aspinhttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxI was thrown off by the ";" with the first 'CASE' for the Commission Flag (I had not used CASE before). I have worked with Crystal Reports for years, even though the Report Builder is not as 'friendly' in a lot of ways as Crystal. It appears it is just as flexable so far.Tue, 05 May 2009 10:11:05 GMTkevlrayhttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxThanks Mark - this sounds like a real timesaver.AdamTue, 05 May 2009 08:49:01 GMTAdam Aspinhttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxAn extra note, instead of typing in feild!col1.value you can use me.value and then apply the formatting to a lot of columns at once. For example if you have several currency columns that need to be red if negative just select them all and in the color expression type iif(me.value<0,”red”,”black”)Tue, 05 May 2009 08:36:51 GMTmarkmeillerhttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxGlad to see the Reporting Services articles. This is a good one. Never would've thought of creating the formatting info back in the sproc... Also nice use of the word "turgid." I had to look it up... :-)Tue, 05 May 2009 08:19:49 GMTBob Griffinhttp://www.sqlservercentral.com/Forums/Topic709928-1497-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Reporting+Services/66247/">Conditional formatting with Reporting Services</A>[/B]Tue, 05 May 2009 00:26:23 GMTAdam Aspin