question

nithintr avatar image
nithintr asked

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

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

Jason Cumberland avatar image
Jason Cumberland answered

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

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

nithintr avatar image
nithintr answered

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

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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