Reporting Services extract single values from dataset

Question

Writing a Reporting Service (2005) report

My DataSet returns something like this:

DESCRIPTION       COUNT
Total Properties  12345
Demolished         1243
Non-Demolished    11102
  :
  :

I have this displayed as a table and this is fine.

Now I also want to display the data like this:

                     [ 12345 ] Total Properties
                       /   \
                     /       \
 Non-Demolished [ 11102 ]   [ 1243 ] Demolished

I can add the text-boxes and lines but what expression do I need to fill in the values? Need somethig that returns the count based on a match to the description in the row.

Answer 1

Maybe you could do something like this:

=Iif(Fields!Description.Value = "Demolished", Fields!Count.Value, "Value not found")

Answer 2

Here is the way to do it.

First(Fields!FieldName.Value,"DataSetName")