SQL Server Performance

Adding cell color depending on value of field ??

Discussion in 'SQL Server Reporting Services' started by dougwood, Jan 27, 2004.

  1. dougwood New Member

    Can anyone tell me how one could change the color of a cell in my matrix report depending on the value of a cell ? ie: if the value of the field is less than 10, i want the cell color to be red, or over 10 , and it should be green ..

    If not, anyone know of any resources out there yet where I could find out this info ??

    thanks so much !
  2. jasper_smith New Member

    In the Properties for the cell colour select <Expression> and in the Expression Editor enter something like
    =iif(Sum(Fields!FieldName.Value)< 10, "Red", "Green")
    where FieldName is the name of the field in question.

    HTH

    Jasper Smith
  3. dougwood New Member

    perfect, thanks a ton.
  4. Justaprogrammer New Member

    Question, is it true that Expression is pretty much the only way to manipulate report objects(Textbox, Lines, Rectangle, Image)?

    Thanks in advance.
  5. jasper_smith New Member

    Pretty much, yes. You can add your own functions etc from the Code tab or custom assemblies but you can only really use them where you see <Expression>

    HTH

    Jasper Smith
  6. Justaprogrammer New Member

    Thanks for the info!!



    quote:Originally posted by jasper_smith

    Pretty much, yes. You can add your own functions etc from the Code tab or custom assemblies but you can only really use them where you see <Expression>

    HTH

    Jasper Smith

Share This Page