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

nithintr gravatar 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

    Jason Cumberland gravatar image

    Jason Cumberland
    507 2

    (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

    nithintr gravatar 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:

    x561

    asked: Jun 09, 2010 at 12:05 AM

    Seen: 2670 times

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