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
  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.
  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
  4. satya Moderator

    When it is dynamic based on the values, then you have to control such operation using the report designer.

Share This Page