none
Does SQL Server 2008 R2 Express Reporting Service support Shared Datasets?

    Question

  • I have spent a few hours trying to get this to work. I am using Report Builder 3.0 (locally), with SQL Server 2008 R2 Express Edition on a remote web server.

    I am running Report Builder as an Admin under Win7 64bit.

    All is OK until I attempt a Save of a newly created shared dataset. The error message is:

    Failed to save dataset "mydataset.rsd"
    The feature "Shared dataset" is not supported in this edition of Reporting Services.

    Details:
    The feature: "Shared dataset" is not supported in this edition of Reporting Services. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Shared dataset" is not supported in this edition of Reporting Services.

    I have researched the web, and the list of features for Express Edition does not list this feature as not being supported, although it does list "Shared component library" as being missing.

    Could anyone please confirm the situation please. If it is  a bug, is there any fix or workaround? 

    John Walton

     

    Thursday, August 19, 2010 11:42 AM

Answers

  • Hi John,

    I got an answer from internal discussion. It is said, Shared Dataset is tied with “Report Part Gallery” in terms of SKU restrictions. As documented here, Report Part Gallery is only available in Standard Edition and above.
    So, I believe Shared Dataset is not supported in SQL Server Reporting Services 2008 R2 Express edition.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Friday, August 27, 2010 1:29 AM
    Moderator

All replies

  • Hi

    I developed a report in 2008 R2 Express which used both Shared Datasets and accessed data via WCF Services.  All was well until I tried to deploy.

    Express does not support Shared Datasets or XML datasources.  I did find a link outlining the unsupported features but I cannot find it again, sorry.

     AndyF.

     PS no fix as such.  Moved to developer version and the clients will have to licence...

     

    • Proposed as answer by AndyF._ Friday, August 20, 2010 7:11 AM
    Thursday, August 19, 2010 12:27 PM
  • Just add to AndyF's response, the comparison can be found here:
    http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Monday, August 23, 2010 11:55 AM
    Moderator
  • Thanks but nowhere there or anywhere else have I found a statement that explicitly states that "shared datesets are not supported" (in Express)!

    John Walton

    Monday, August 23, 2010 2:19 PM
  • Hi, I am newbie but pretty familiar with reporting services. Are you sure that your report server project is set to SQL Server 2008 R2 format before publishing? Specifically, I had a similar problem until I changed the default setting for the project in BIDS. Under the RDL project's properties change the TargetServerVersion to SQL Server 2008 R2, then try to republish to the express instance running reporting services. I think it will work.
    • Edited by Jordan B Tuesday, August 24, 2010 9:46 PM typo
    Tuesday, August 24, 2010 9:46 PM
  • I just saw that you are using ReportBuilder 3.0. I'm not sure where that setting is in that application, but I would try it from BIDS first, if you still have the problem then double-check that the instance is SQL Server 2008 R2 Reporting Services.
    Tuesday, August 24, 2010 10:03 PM
  • Thanks for trying (and previous reply from Jordan 8).

    1. Report Builder 3.0 has no option to change properties of Report Server.

    2. So I went to the trouble of installing BIDS. Then quite a learning curse! When I eventually tried to Deploy (i.e. save) a Shared dataset on my report server (correctly identified as SQL 2008 R2), it aborted with: 

    Error rsOperationNotSupported : The feature: "Shared dataset" is not supported in this edition of Reporting Services.

    So I think that with this and earlier test, I can conclusively say that SQL Server 2008 R2 Express Edition does not support shared datasets, although it does support shared data sources. And I still have found anywhere that definitely says this is the case!

    I now need to determine which is next level up of he server that does support shared datasets. i.e. Does Web Edition?

    John Walton

    Wednesday, August 25, 2010 1:35 PM
  • Well, I just re-tested this issue you encountered and I get the same error message. I had this same issue back on May 13th and all I know is that one of 2 things must have happened:

    1. I imagined that it worked or I was using a pre-release version of the product.

    2. An update to my installation has broken this feature.

     

    You can see my original thread here where I was convinced that this works. I know it doesn't help you right now, but it definitely confuses me. Sorry for the bad advice.

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/4ccbdfbf-d2f1-4808-9477-b86866fff2d1

    • Edited by Jordan B Wednesday, August 25, 2010 6:31 PM typo
    Wednesday, August 25, 2010 6:28 PM
  • I did find some additional information on supported features in the product, none explicitly mention that Shared Datasets are restricted in Express. I have a copy of Developer edition and am trying this now from the same workstation where I have the Express instance so we'll see what happens.

    Features Supported by Reporting Services in SQL Server Express

     http://technet.microsoft.com/en-us/library/cc281020.aspx

    Reporting Services in SQL Server Express with Advanced Services

     http://technet.microsoft.com/en-us/library/ms365166.aspx

    These articles look to have been updated for the R2 release but I guess there are no guarantees.

    • Edited by Jordan B Thursday, August 26, 2010 2:43 PM links broken
    Wednesday, August 25, 2010 6:35 PM
  • Okay I just pointed my ReportServer project to a Developer Edition instance of Reporting Services R2 and the Shared Dataset deployed sucessfully. My understanding is that Developer edition is the same feature set as DataCenter/Enterprise edition but with a licensing restriction only.

    SQL Server Developer lets developers build any kind of application on top of SQL Server. It includes all the functionality of SQL Server Datacenter, but is licensed for use as a development and test system, not as a production server. SQL Server Developer is an ideal choice for people who build and test applications. You can upgrade SQL Server Developer for production use.

    This edition is very inexpensive. I believe we purchased it for less than 99 dollars. It is still perplexing that I cannot get the Shared DataSets to deploy in Express, but I may be having an issue with the instance. I may go back and create a new Express r2 instance to see what happens

    Wednesday, August 25, 2010 7:05 PM
  • I found a slightly different but similar breakdown of the editions and features supported posted previously by Jin.

    Features Supported by the Editions of SQL Server 2008 R2
    http://msdn.microsoft.com/en-us/library/cc645993.aspx#Dev_tools

    Review the Developement Tools, Reporting, and Business Intelligence Clients sections of the list.

    This one specifically mentions BIDS as supported on Express Advanced Services and states that Report Builder 3.0 is not supported on Express Advanced Services.

    The only plausible thought I had is that by saying they don't support Report Builder 3.0 on Express Edition with Advanced Services, they are implying that Shared DataSets do not work.

    Of course, they both work with the edition, BIDS and RB 3.0, but give the error messages for Shared DataSets.  I did notice that when you install 2008R2E with AS, report builder does not appear in the report manager. In order to use it, you have to download it separately, or you can call the http link to Report Builder manually and it will launch. In my case, it was: http://localhost/reportserver/reportbuilder/ReportBuilder_3_0_0_0.application

    Wednesday, August 25, 2010 7:54 PM
  • Okay, so I created a new instance of Reporting Services using SQL Server 2008 R2 Express Edition with Advanced Services and I continue to have the same error, "'Shared dataset' feature is not supported on this edition of Reporting Services".

    I do not have this problem with the Developer Edition of this same product. I am taking a stab in the dark, but I would say that Shared DataSets are support on any version of the product where Report Builder 3.0 is supported, which in this case would be  DataCenter, Enterprise (implies Developer), Standard, and Workgroup edition.

    Shared Datasets appear to not be supported on the Web, Express with Advanced Services, Express with Tools, or Express edition of SQL Server 2008 R2.

    Good luck out there!

    Wednesday, August 25, 2010 8:18 PM
  • Hi John,

    I got an answer from internal discussion. It is said, Shared Dataset is tied with “Report Part Gallery” in terms of SKU restrictions. As documented here, Report Part Gallery is only available in Standard Edition and above.
    So, I believe Shared Dataset is not supported in SQL Server Reporting Services 2008 R2 Express edition.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Friday, August 27, 2010 1:29 AM
    Moderator
  • Hey Jin. 

    I as trying to play around with SQL 2008 R2 Express and the Samples Reports Database. I've tried to deploy the AdventureWorks2008R2 Sample Reports and kept ketting the Shared DataSet not supported message.

    But then, following Jordan B's advice, I accessed: http://localhost/reportserver/reportbuilder/ReportBuilder_3_0_0_0.application.

    It downloaded 78,3 MB and it installed ReportBuilder 3.0. After that, I've tried deploying it again and it worked. 

    I just tought y'all should know.

    Monday, September 13, 2010 1:37 PM
  • Hello Jin,

    I want to know if shared datasource and dataset is  possible in 2008 express edition without using report builder .I have a number of reports which uses same datasource and dataset which comes from an XML. So I really have to make them shared but when I run this it gives an error saying that the execution failed for the shared dataset .Is it so that it is not possible to use shared dataset in express edition?If not then will have to go with another versions.

    thanks,Reema

    Monday, March 21, 2011 8:38 AM
  • I'm using SQL Server 2008 R2 Web edition and getting the same error about shared datasets not being supported. Can you confirm that shared datasets aren't available in this edition even though it is a paid edition of SQL Server 2008?
    Friday, August 12, 2011 8:14 PM