SQL Server Performance

Change Background Color Dynamically in SSRS Report

Discussion in 'SQL Server 2005 Reporting Services' started by Sandy, Mar 26, 2009.

  1. Sandy New Member

    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.
  2. patel_mayur New Member

    Hi Sandy,
    You can use "Expression" for setting the background color for particular condition.
    Regards,
    Mayur.
  3. Sandy New Member

    Mayur,i
    am able to change now.
    I simply missed one or condition so I changed it and its working fine.
    Thanks,[:)]
    Sandy.

Share This Page