-
selecting fields from 2 datasets
Need syntax for selecting fields from 2 different datasets in one report.
Each dataset connects to a different server.
-
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
-
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|