SQL Server Performance

Textbox Background color Value

Discussion in 'SQL Server 2008 Reporting Services' started by hai_jeyakumar, Apr 26, 2009.

  1. hai_jeyakumar New Member

    Hi
    I need to assign the background color to the text box , based on the another text box background color value(its dyanmic)
    Please let me know if you have any solutions or suggestion for this.
    Thanks
    Jay
    hai_jeyakumar, Apr 26, 2009
    #2

  2. satya Moderator

    Welcome to the forums.
    Are you using SQL 2008 Reporting Services or previous version?
    Go to the table row's BackgroundColor property and choose "Expression..."
    Use this expression:
    =IIf(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")

    This trick can be applied to many areas of the report.
    satya, Apr 27, 2009
    #3

  3. hai_jeyakumar New Member

    Hi
    Thanks for your suggestion. I am using the SQLSERVER 2008, I have tried this option, its working fine, if the table doesnt' have the grouping.
    If any groups(row group, column group) exists in the table , its retuning the same color.
    Thanks & Regards
    Jay
    hai_jeyakumar, Apr 27, 2009
    #4

  4. satya Moderator

    When it is dynamic based on the values, then you have to control such operation using the report designer.
    satya, Apr 27, 2009
    #5

Share This Page