"Erik Tamminga" <newsgroups@NeOtammiSnPgAaM.nl> wrote in message
news:cbkt5q$m1m$1@news5.tilbu1.nb.home.nl...
> Hi,
>
> It would be very nice if the following feature would somehow be
implemented
> in future releases:
>
> - A report with two datasets
> - A list on the report consuming records from dataset 1
> - A list inside the existing list consuming records from dataset 2 with a
> filter defined that allows an expression on a value from the current
record
> in dataset 1
>
> This would allow us to create a master-detail report consuming two
different
> databases/queries without using sub-reports.
>
> Thanks,
>
> Erik
>
>

"Erik Tamminga" <newsgroups@NeOtammiSnPgAaM.nl> wrote in message
news:cbkt5q$m1m$1@news5.tilbu1.nb.home.nl...
> Hi,
>
> It would be very nice if the following feature would somehow be
> implemented
> in future releases:
>
> - A report with two datasets
> - A list on the report consuming records from dataset 1
> - A list inside the existing list consuming records from dataset 2 with a
> filter defined that allows an expression on a value from the current
> record
> in dataset 1
>
> This would allow us to create a master-detail report consuming two
> different
> databases/queries without using sub-reports.
>
> Thanks,
>
> Erik
>
>

> Yes, this is heterogenous join. While it is simple to design, it is pretty
> complex to make it perform. It is high on the list for a future release.
>
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Erik Tamminga" <newsgroups@NeOtammiSnPgAaM.nl> wrote in message
> news:cbkt5q$m1m$1@news5.tilbu1.nb.home.nl...
> > Hi,
> >
> > It would be very nice if the following feature would somehow be
> > implemented
> > in future releases:
> >
> > - A report with two datasets
> > - A list on the report consuming records from dataset 1
> > - A list inside the existing list consuming records from dataset 2 with
a
> > filter defined that allows an expression on a value from the current
> > record
> > in dataset 1
> >
> > This would allow us to create a master-detail report consuming two
> > different
> > databases/queries without using sub-reports.
> >
> > Thanks,
> >
> > Erik
> >
> >
>
>