Search code examples
sqlreporting-servicesreportingservices-2005

Report with 2 Shared Data Sources in SSRS 2005

I am fairly new to SSRS and am stuck using 2005 right now. I am developing a report in a solution that has 2 Shared Data sources. I have a column in data source A that needs to be tied to a column in data source B.

I saw some stuff saying that pre-2008 has a harder time doing this, and I also saw info on sub-reports but it didn't quite seem to fit what I need. I've also tried to bring it in as a hidden parameter, but haven't had too much luck there.

Is there an easier way to do this that I am missing? Thanks for the help.

Solution

  • Linked Servers...Woot Performance is a little slow but not terrible