"JIM.H." <JIMH@discussions.microsoft.com> wrote in message
news:66B1FAB7-23EB-4A77-8DD5-01907952F63E@microsoft.com...
> Hello,
> Is there any function like dlookup in reporting services. I need to bring
> some data from another table..
> Thanks,
> Jim.
>
>

"Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message
news:eK7Rcm%235EHA.3124@TK2MSFTNGP11.phx.gbl...
> No, there is not. Joining datasets in reports is on the wishlist for a
> future release.
> The closest alternatives you have in RS 2000 are:
> * use aggregate functions to access fields from other datasets. However,
> this won't work for lookup purposes.
> * join the lookup data in the dataset query, so you have the information
> available as additional field in the current dataset.
> * implement lookup functionality by using a custom assembly which gets the
> data on its own (however this may not be trivial to do).
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "JIM.H." <JIMH@discussions.microsoft.com> wrote in message
> news:66B1FAB7-23EB-4A77-8DD5-01907952F63E@microsoft.com...
> > Hello,
> > Is there any function like dlookup in reporting services. I need to
bring
> > some data from another table..
> > Thanks,
> > Jim.
> >
> >
>
>