Joining two tables from different datasources

Hi,
I have a requirement in which I need to create a report by joining two tables from two different datasources. Please let me know how can I do it.

Thanks in advance for any help.

Thanks,
Susmitha.

Find more posts tagged with

Comments

mwilliams

Hi Susmitha,

Can you explain more of what you're wanting to do? Does a joint dataSet not solve your issue?

Susmitha

Hi Michael,
Thank you very much for your reply. I have dataset a from x datasource and dataset b from y datasource. both tables has a common column. How can I join both the tables? Is there a way to achieve this.

Thanks in advance for your help.

Thanks,
Susmitha.

mwilliams

Susmitha,

Yes, if you create a joint dataSet, you can join the two dataSets on the common column. To create a joint dataSet, just right click on dataSets in your data explorer and choose new joint dataSet. Let me know if you have questions.

Susmitha

Thanks Michael. That works for me.

Thanks again
Susmitha.