InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 11:34:00 GMT20http://www.sqlservercentral.com/Forums/Topic1413700-1063-1.aspxIn SSRS 2005 I think you would need to have the sales values for different dates returned in the same row in the dataset. So that involves modifying your query possible using PIVOT or something like that.In newer versions you can refer directly to other cells in the matrix using this: ReportItems!Textboxname.valueYou could create an expression in the format property something like=IIf(Fields!Column.Value > ReportItems!TextBoxName.value,"Green",IIf(Fields!Column.Value < ReportItems!TextBoxName.value,"Red","Black"))The formatting formula would be similar if you have to use the first option, it would just refer to two fields at the same grouping/details level.Tue, 05 Mar 2013 17:51:01 GMTdavoscollectivehttp://www.sqlservercentral.com/Forums/Topic1413700-1063-1.aspxHi,I just created a matrix report with consecutive dates running along the y-axis and sales people running down the x-axis.Is there a way to show if a sales figure has an increase from the previous date as green and red if it has decreased?Any help welcome.Thanks,EamonWed, 30 Jan 2013 10:02:22 GMTEamonSQL