Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2002
    Posts
    77

    Unanswered: ssrs conditional formating

    I want to do conditional formating on a data set.

    I have a data set (let's call it data set 2) in the project that has a list of values( 1 coumn, multiple rows)

    Then the report based on a another data set. I want to change the font color to red if the value of a field called the network matches any of the values in data set 2.

    I have the following code, but it only formats one value. Any one know how to format all the values in data set 2


    iif(Fields!network.Value Like first(Fields!network.Value, "topten"),"Red","Black")

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Quote Originally Posted by vld
    iif(Fields!network.Value Like first(Fields!network.Value, "topten"),"Red","Black")
    That is Access code, this is the SQL Server Forum.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Jan 2002
    Posts
    77
    obviously you haven't worked with SSRS

  4. #4
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Quote Originally Posted by vld
    obviously you haven't worked with SSRS
    Indeed, that will be something for next year, after we have migrated to SQL Server 2008. Sorry, my bad.
    I saw "iif", and I associate that with Access.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Have you checked this link?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •