Embedded Data Source Question RRS feed

  • Question

  • In an SSRS 2008 report I created (in VS 2008), I used an embedded data source. When I copy this report to our SSRS 2008 reporting server, am I still able to use this embedded data source, or do I have to use a data source defined on the reporting server?


    Monday, December 13, 2010 5:58 PM


  • Hi,

    If the datasource is embedded, you would not require the definition of the data source in the report server. The embedded connection details is sufficient.

    Yet having a defined datasource and using it as a shared data source would simplify multiple report development when they are all referring the same data source. When you happen to move the datasource to a different server, with shared data source, all you need to do is modify the datasource where as in embedded connection it would draw you to change each report's connection.

    Hope this helps.


    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.


    • Proposed as answer by Challen Fu Tuesday, December 14, 2010 6:03 AM
    • Marked as answer by Challen Fu Tuesday, December 21, 2010 10:15 AM
    Tuesday, December 14, 2010 3:31 AM