Does SQL Server 2008 R2 Express Reporting Service support Shared Datasets?
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
August 19th, 2010 2:42pm

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...
Free Windows Admin Tool Kit Click here and download it now
August 19th, 2010 3:27pm

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 ChenJin Chen - MSFT
August 23rd, 2010 2:55pm

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
Free Windows Admin Tool Kit Click here and download it now
August 23rd, 2010 5:19pm

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.
August 25th, 2010 12:46am

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.
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2010 1:03am

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
August 25th, 2010 4:35pm

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
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2010 9:28pm

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.
August 25th, 2010 9:35pm

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
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2010 10:05pm

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
August 25th, 2010 10:54pm

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!
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2010 11:18pm

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 ChenJin Chen - MSFT
August 27th, 2010 4:29am

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.
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2010 4:37pm

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
March 21st, 2011 4:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics