"Phil" <Phil@discussions.microsoft.com> wrote in message
news:B5A93CAB-CA71-45B4-8BCF-391C31C3FF52@microsoft.com...
> Hi,
>
> We are having a problem with Reporting Services and are wondering whether
it
> is a limitation in the current version, or whether we just don't know how
to
> implement something. We are attempting to create a report that is based on
> information contained in two databases. When the user opens the report, we
> want them to be able to enter a skill (i.e. "Maths"), and then the report
> will take that skill and query an SQL Server database for a list of IDs
for
> all Teachers who have that skill. We then want to take that list of IDs
and
> query on Oracle database for each one, so that we can get information
about
> those teachers.
>
> A simple example is as follows:
>
> The SQL server contains the following data:
>
>
> TeacherID Skill
> 1 Maths
> 2 English
> 3 Maths
> 4 Trombone
>
>
> The Oracle database contains the following data:
>
>
> TeacherID Name
> 1 Phil Price
> 2 Jed Moss
> 3 Jack Frost
> 4 Santa Claus
>
>
> The user enters a skill ("Maths"), and we want to return the names of all
> teachers with that skill. So we query the SQL database for all the teacher
> IDs with Maths as a skill. It will return 1 & 3. Now for those IDs we want
to
> get the names out of the Oracle database. However, we cannot get Reporting
> Services to take the list of IDs and, for each one, return the names and
> display them to the screen. Is there any way to pass a result set from one
> query as a parameter for another query? Is there something we're missing?

"RK Balaji" wrote:

> Try creating a parameter that is query based against the SQL Server database
> where the label field is skill and the value field is teacher id. Once the
> user selects the skill, you can query against the oracle database using the
> parameter which will now have the teacher id..
>
>
> "Phil" <Phil@discussions.microsoft.com> wrote in message
> news:B5A93CAB-CA71-45B4-8BCF-391C31C3FF52@microsoft.com...
> > Hi,
> >
> > We are having a problem with Reporting Services and are wondering whether
> it
> > is a limitation in the current version, or whether we just don't know how
> to
> > implement something. We are attempting to create a report that is based on
> > information contained in two databases. When the user opens the report, we
> > want them to be able to enter a skill (i.e. "Maths"), and then the report
> > will take that skill and query an SQL Server database for a list of IDs
> for
> > all Teachers who have that skill. We then want to take that list of IDs
> and
> > query on Oracle database for each one, so that we can get information
> about
> > those teachers.
> >
> > A simple example is as follows:
> >
> > The SQL server contains the following data:
> >
> >
> > TeacherID Skill
> > 1 Maths
> > 2 English
> > 3 Maths
> > 4 Trombone
> >
> >
> > The Oracle database contains the following data:
> >
> >
> > TeacherID Name
> > 1 Phil Price
> > 2 Jed Moss
> > 3 Jack Frost
> > 4 Santa Claus
> >
> >
> > The user enters a skill ("Maths"), and we want to return the names of all
> > teachers with that skill. So we query the SQL database for all the teacher
> > IDs with Maths as a skill. It will return 1 & 3. Now for those IDs we want
> to
> > get the names out of the Oracle database. However, we cannot get Reporting
> > Services to take the list of IDs and, for each one, return the names and
> > display them to the screen. Is there any way to pass a result set from one
> > query as a parameter for another query? Is there something we're missing?
>
>