Multiple data sources
hi..
can anybody tell me how to generate a report using multiple datasources ..
Please tell me in step by step procedure...
thank u in advance...
Rishi
December 14th, 2010 12:50pm
The easiest is if you write a stored procedure with parameter(s). Within the stored procedure you design the multiple data source access logic.
Related link:
http://www.sqlusa.com/bestpractices2008/stored-procedure-parameters/
Kalman Toth, SQL Server & Business Intelligence Training; SQL Server 2008 Training
Free Windows Admin Tool Kit Click here and download it now
December 14th, 2010 1:34pm
For SQL 2005: Within BIDS (Visual Studio) 1. Create a shared datasource in your project for each source. 2. on the dataset tab add each dataset 3. On the layout, add your data.
December 14th, 2010 1:34pm
Hi Rishi,
We are able to add more than data sources to a report. For the detailed steps, please refer to the link:
http://msdn.microsoft.com/en-us/library/ms159165(v=SQL.90).aspx
After multiple data sources were added to the report, we can add datasets based on data sources. Please notice that each dataset can only against one data source. For more information
about adding dataset, please refer to the link:
http://msdn.microsoft.com/en-us/library/ms160345(SQL.100).aspx
After that, we can use data fields of datasets in the report. Please also be aware that for each data region (Table, Matrix, Chart), only one dataset can be specified.
However, if you have some further needs, please elaborate your current scenario and requirement with more details.
Thanks,
Tony Chain Tony Chain [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
December 16th, 2010 3:46am