September 19, 2011 at 11:56 pm
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
=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