Changing label of y-axis -- sql server reporting services

Ben
7/16/2006 10:49:01 AM

For my report i have to change the label of the y-axis. My dataset is
returning integer values "0", "1", "2". These values are now shown as the
label. However, i need to translate these ID's to string values, such as "0"
= "no value available", "1" = "service down", "2" = "service up".

I have tied to insert a code snippet for conditinal names in the Label
Format Code field
=IIF(Fields!Parameter.Value=0, "no values available", Fields!Parameter.Value)
but this does not solve the problem, because it seems i can only use
formatting code in the label field.

Is there a way to do this or do i have to label my y-axis as is and insert a

Tim Dot NoSpam
7/16/2006 2:42:10 PM

For the series or category (I forget which one is the y-axis), specify the
following instead of just "Fields!myvalue.value"

=IIF(Fields!myValue.value = 0, "No value available",
IIF(Fields!myValue.Value = 1, "Service Down", "Service Up"))

Replace "myvalue" with the actual name of your column.

[quoted text, click to view]

sql server reporting services : Changing label of y-axis