"Cindy Lee" <dangreece@hotmail.com> wrote in message
news:eBnL6uYVEHA.1928@TK2MSFTNGP11.phx.gbl...
> I was reading the help, but I don't know if this is possible.
>
> Dataset
>
> first | last | Id
> a | b | 1
> c | d | 2
> e | f | 3
>
>
> For 1 cell I want to put:
> Fields!ID.Value where Fields!First.Value="c" and Fields!Last.Value="d"
>
> I just want to put specific fields in different spots. I didn't see this
in
> the help and looked around a bit. Is there a section in the help that
> covers expressions like this?
>
>

"Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message
news:u4AUaamVEHA.2716@tk2msftngp13.phx.gbl...
> I think you want this:
> =iif(Trim(Fields!First.Value) = "c" AND Trim(Fields!Last.Value) = "d",
> Fields!ID.Value, Nothing)
>
> Details on the IIF function are available on MSDN:
> http://msdn.microsoft.com/library/en-us/vblr7/html/vafctiif.asp
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "Cindy Lee" <dangreece@hotmail.com> wrote in message
> news:eBnL6uYVEHA.1928@TK2MSFTNGP11.phx.gbl...
> > I was reading the help, but I don't know if this is possible.
> >
> > Dataset
> >
> > first | last | Id
> > a | b | 1
> > c | d | 2
> > e | f | 3
> >
> >
> > For 1 cell I want to put:
> > Fields!ID.Value where Fields!First.Value="c" and Fields!Last.Value="d"
> >
> > I just want to put specific fields in different spots. I didn't see
this
> in
> > the help and looked around a bit. Is there a section in the help that
> > covers expressions like this?
> >
> >
>
>