selecting fields from 2 datasets

[PRAR]

Need syntax for selecting fields from 2 different datasets in one report.

Each dataset connects to a different server.

[Island1]

Some clarification, please ... you say "report..."

Multiple data regions with different datasets in each (easy), or are you trying to hit two datasets with a single data region (more involved - you'd have to handle the combination in a view in the RDBMS or some such - assuming that you're not working with a cube - you don't give these details) ?

As you probably know, you can have multiple regions in a report ... a few more details might make it easier to offer options ...

Hope I can help ...

Bill

[PRAR]

Sorry,here some more details.

In the same report i´ve created two datasets:

Datasource1 like this:data source=SMDDDSKDKSGD001;initial catalog=CAAMDB.
Dataset is named CAAMDB - Table to select fields from = Rassetman

Datasource2 like this:data source=SQLSERV;initial catalog=FBI.
Dataset is named FBI - Table to select fields from = Profile

So i have to select field1,field2 from Rassetman, field1, field2 from Profile where field3 in Profile = field3 in Rassetman

[fatherjack]

Prar,
the best way to run this would be to create a distributed query on one of your data servers that returns the combined dataset that you want the report to use, then point your report at that single view/sproc.