SSRS report combine data sources and generate csv

Question

question

nithintr asked Jun 9, '10

SSRS report combine data sources and generate csv

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.

ssrs

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-06-09T14:36:24Z

Jason Cumberland answered Jun 9, '10

You cannot merge 2 datasets in an SSRS report. You can do this a few ways:

Create a user database that you own and create a procedure in this database that joins the data using three part naming (assuming they are on the same server), then hit that procedure with your report
Create an SSIS ETL package that extracts the data you need to another database
Create an SSIS ETL package that grabs the data on the fly and set up the report to call the package and use that as your dataset source
Create a dataset lookup function in the code block of the SSRS report and do lookups from one dataset to the other.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2010-06-15T11:05:04Z

nithintr answered Jun 15, '10

Thanks for your reply. I cannot use SSIS. I have to export the report as csv. Im still researching how to remove the header. i tried the Noheader option in the config file but it did not help. The header still shows up in the csv file.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question