"bobfoc" wrote:

> iif(Fields!name.Value = 1, "Top Information",
> iif(Fields!name.Value = 2, "Middle Info",
> iif(Fields!name.Value = 3, "Bottom info",
> "unknown info")))
>
> hope taht helps, feel free to ask anymore questions i know what it's like
> just startin in reporting services, it takes a while to get to grips with it!
>
> bobfoc
>
> "Bill" wrote:
>
> > New to this.
> > Im teaching myself this so bear with me thx.
> >
> > I have a report where each section returned i.e. 1, 2, 3..
> > has information
> >
> > what I would like to do is rather then having it show 1 say for the section
> > I would like it to subsititue the proper text based on the number
> > i.e.
> > 1 = Top Information
> > 2 = Middle Info
> > 3 = Bottom Info
> >
> > I am trying to figure out if I can use the Iff command to do this
> > I have seen the examples for the color changes but can not seem to figure
> > out if I can substitue text
> >
> > any clues would help a bunch
> >
> > thanks