SSRS report combine data sources and generate csv

Question

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.

Thanks in advance.

Answer 1

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.

Answer 2

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.....

Answer 3

are the databases on the same server? if so, i would cheat and use a union all to join the data in the data set.

Answer 4

To remove anything from a report when exporting it, you must select the textbox and goto properties. Find the DataElementOutput and set it to No Output.