x

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.

more ▼

asked Jun 09, 2010 at 12:05 AM in Default

avatar image

nithintr
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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

answered Jun 09, 2010 at 02:36 PM

avatar image

Jason Cumberland
507 1 2 4

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Jun 15, 2010 at 11:05 AM

avatar image

nithintr
1 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x660

asked: Jun 09, 2010 at 12:05 AM

Seen: 3200 times

Last Updated: Jun 09, 2010 at 12:05 AM

Copyright 2016 Redgate Software. Privacy Policy