SQL 2008 R2 to SQL 2008 reports RRS feed

  • Question

  • User-834199234 posted


    I have several reports created in BIDS 2008, my problem is I created several reports in the version installed by R2, Microsoft schema 2010.  I need to publish and run the reports on a server running SQL 2008.  I have seen a few posts on changing the schema to 2008 and deleting  the reportsections.  I have changed the schema but am running into a problem with a shared dataset.  What changes should I make to a shared dataset to make it campatible with a 2008 schema?  Do I need to delete all of the reportsections?  Are there any other changes I need to make?


    Sunday, October 2, 2011 10:13 PM


  • User-830595639 posted

    Hi KLB,

    Shared dataset is a feature of 2008 R2, so if you want to change your reports to 2008 then you need to create embeded dataset for each of your report.

    I hope this will help you.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 3, 2011 2:00 AM