I am new to ssrs. I have a report that gets data from two databases. I can create two datasets that connect to two different databases. The databases are third party and I cannot create stored procedures on the databases. My issue is that I have to combine the data from the two queries.
Please help me with this issue or point me to locations where I can find answers.
I don't know how you would accomplish this in SSRS. Are you looking to get the data out in structured report format? Or just in a raw data format? If it is the latter, I would recommend taking a look at SQL Server Integration Services (SSIS). Lots of tools for manipulating data from multiple data sources and outputting in many different ways.
Check out the SQL Server Reporting Services Dev Center on MSDN.
Or Google or Bing for "Reporting Services Tutorial" - I guarantee you'll get thousands of hits......
What you need to do is pretty basic - just drag & drop those columns / fields you need onto your report.....
are the databases on the same server? if so, i would cheat and use a union all to join the data on the server side in your data set. if you are using a stored procedure use union all in the stored procedure. if you're doing an ad hoc query in the data set (which is bad practice, but whatever) put a union all in there.
