Post reply

Back Ground Colours to the report fields

  • September 19, 2011 at 11:56 pm

    #257752

    hi friends

    In my report builder designer there are only two value fields one is Team and second is details when I run the report there I am getting 5 fields which are the levels in Team I need to apply colours to each of the levels that which comes only when we run the report how can i do this for this report we use MDX Query

  • September 20, 2011 at 12:16 am

    #1383638

    =iif(Fields!dataset.column.value = "condition", "Green", "Red")

    first - focus on the column that will define the result

    second - if true colour

    third - if false colour

    you can have multiple FALSE conditions:

    =iif(Fields!dataset.column.value = "condition", "Green", iif(Fields!dataset.column.value > 9, "Blue", etc.....

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 2 posts - 1 through 1 (of 1 total)

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