Hi All, I need a small help for the above topic. I have report which displays the Details of expenses report in SSRS. Report Format =================================== Period No. of emp exp --------------------------------- 2009 45 1000 Qtr 1 20 2000 Jan 10 1000 I want to change the background color of each row as per the period. If my period is "2009" or numerical data then "Green", If its Qtr 1, Qtr 2....etc then "Grey", If its Jan, feb...etc..Then "Red". I tried the logic for a single column in another report build by SQl Stored procedure its working fine but The report is build by the MDX and instead of Value, I am taking field. Label but its not working. Can anyone help me please? Thanks, Sandy.
Hi Sandy, You can use "Expression" for setting the background color for particular condition. Regards, Mayur.
Mayur,i am able to change now. I simply missed one or condition so I changed it and its working fine. Thanks,[] Sandy.