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.
| Author |
Topic |
|
vinaynaran
Starting Member
9 Posts |
 Posted - 2010-11-26 : 07:10:43
|
| Dear all,In reporting Service I would to do conditional formatting In Matrix Report.I have months across using column heading and under Neath Sales value by month My report format like belowPg Pg Desc January February March April May June July August SPD SPD SPD SPD SPD SPD SPD SPD470 Misc. Adjuster Parts Headlight 144.6507 148.3086 187.5844 155.3691 183.3279 179.1496 118.5894 199.2665471 Headlamp Complete 11013.86 11459.44 11094.28 10930.86 10197.57 10162.77 9666.199 9947.257472 Headlamp Inserts & Glasses 167.6196 293.7945 233.4436 199.0941 206.0028 164.5267 207.8559 212.193What I want: I want conditional format by month where ever sales value less than previous month.Example: If February Sales less than January Sales then Colour RED else Green in any products and so on for other months.Please can you help me.Vinay |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-11-27 : 02:45:54
|
| you can add a expression for color property of font in matrix like=IIF(Fields!ThisMonthsales.value < Fileds!LastMonthSale.Value,"Red","Green")make sure you used correct field names------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
vinaynaran
Starting Member
9 Posts |
Posted - 2010-11-29 : 05:25:58
|
| Dear VisakhThanks for answer but…How do I identify current or previous monthPlease see below my design view of Matrix report MnthPg Pg Desc [Sum(SPD])So month Is coming across Like (Jan, Feb, Mar…) automatically using Matrix report.Please help me. |
|
|
|
|
|
|
Condtional Format in Matrix report By month