reporting services - Help with pulling data from different database servers in SSRS 2008 -


I am working with SSR2008 and I need some help on how I should face it.

My requirement is that I need to make an SSR report, which results in the need to drag me from different databases into different servers to show results. There is a unique ID in Database 1 which I can use on query with more information on database2 .

I'm not sure that the sub-report will have to do the trick.

I do not have a linked server and is there any way i can pull information from different database servers and join them?

Thank you.

Your easiest way would be to use it to pull data from another location and Allows to be in the form of a table.

Comments