Post reply

Dynamically changing colors of the cell/row

  • June 8, 2005 at 6:09 pm

    #152432

    Hello !
     
        I am using Reporting Services with SQL Server 2000 (SP3).

        I am trying to build in dynamic coloring into my report depending on the value in a certain field. Query already returns name of the color I would like to use as an additional field (color conditions are driven by range of data certain value falls into and stored in the database ). I simple need to pick color stored in this field( it is Dataset field Color) and apply to particular cell (possibly entire row) when rendering report. Colors are returned as names: GREEN,RED,GREY etc.

       Is there an easy way to accomplish this in Reporting Services?
        Any help would be greatly appreciated.
     
    Igor

  • June 8, 2005 at 6:45 pm

    #564038

    Have you tried using an expression in the 'Color' property for the textbox (ie cell) in the report?  I imagine it would look something like

    = Fields!MyColorColumn.Value

    HTH,

    Steve.

  • June 8, 2005 at 6:48 pm

    #564039

    Thanks, Steve! I have figured this out after I posted my question. It worked nicely.

    Thanks again,

    Igor

  • June 10, 2005 at 1:29 pm

    #564776

    Here's a good explaination:

    http://www.sqlservercentral.com/columnists/bknight/reportingservicesconditionalformatting.asp

    Greg

  • June 10, 2005 at 1:48 pm

    #564796

    Thanks a lot Greg! Very useful.

    Igor

     

     

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply