Error Message When Using a New Feature in SSRS 2008 R2

January 4, 2011

We installed SQL Server 2008 R2 about 2 months ago, and I recently tried to use a new feature in Reporting Services 2008 R2. I used the Business Intelligence Development Studio (BIDS) to open a new Report Server Project. After creating a data source I also defined a shared dataset (a new feature to SSRS 2008 R2). I put some of the fields into a table and tried to run the report (still inside the BIDS).  But I failed with an error:


The report preview failed because the report could not be built. Read the errors, warnings and messages in the Error List window for specific build features.


The data set, DataSet1, is a shared dataset. SQL Server 2008 Reporting Services does not support shared data sets.



 


I couldn’t get it. I’m using BIDS from SQL Server 2008 R2 – what do you mean it’s not supported? :S
Help was on the way quite quickly from Microsoft support Israel. Apparently, though I am using the BIDS from SQL Server 2008 R2, I still need to define my Target Server Version to SQL Server 2008 R2. The default setting is (for some reason) set to SQL Server 2008 (hence the error message).



Guess that just goes to show me, it’s all about the little things (as always ;)).

Add comment
facebook linkedin twitter email

Leave a Reply to Seth Cancel Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

8 comments

  1. SethJanuary 19, 2011 ב 17:33

    Thanks – I just encountered this problem and then landed on your blog page – nice one.

    Reply
  2. ArvindFebruary 9, 2011 ב 15:24

    Hi i had the same error and i have managed to fix it by changing the report folder properties.

    go to the folder where the report(.rdl) file is stored and right click on the folder to see the folder properties, uncheck ‘Read-only’ check box and apply changes to all the subfolders under it. if everthing goes fine you should be able to preview the report. Hope this helps. Cheers

    Arvind

    Reply
  3. KinshowaMarch 23, 2011 ב 21:59

    Wow, thanks. You just saved me a lot of pain in trying to figure out what was going on here.

    Reply
  4. Matter73May 12, 2011 ב 1:55

    thanks… big time.

    Reply
  5. TBJuly 13, 2011 ב 21:15

    Great tip, just helped a user recover from two days of frustration trying to get reports to run. Thanks!

    Reply
  6. Praveen July 15, 2011 ב 12:13

    I had exactly same issue, similar issue, unchecking ‘Read-only’ check box and apply changes to all the subfolders had done the job. Thanks Arvind.

    Reply
  7. sundarAugust 18, 2011 ב 10:48

    I am getting #error while displaying ssrs 2008 R2

    Reply
  8. AffuSeptember 30, 2011 ב 17:17

    Great job un-checking the Read only works great

    Reply