Previewing reports in report builder 2.0

Posted on 2009-12-16
Medium Priority
Last Modified: 2012-06-21
I'm having a big problem.  I have created several reports on a report server in report builder 2.0.   I am currently using an embedded data source.   at first I was able to preview my reports with no problem but now  when I go to preview my reports I'm getting this error saying
"This report cannot be run in report builder because it contains one or more embedded data sources with credential options that are not supported.  Instead of embedded data sources use shared data sources or save and view the report on the server."  I've creating a shared datasource but it's still not working.  Please help

Question by:dlavar
  • 2
LVL 16

Accepted Solution

Auric1983 earned 2000 total points
ID: 26071282

Are the datasources setup to request credentials each time the report executes?

Two things to check.

Review the Documentation on the MSDN: http://msdn.microsoft.com/en-us/library/dd220515.aspx 

And I'm not sure if this applies, but according to this blog there is a bug in Report Builder 2.0 > http://blog.hoegaerden.be/2009/09/12/report-builder-2-0-cannot-switch-data-source/

Author Comment

ID: 26072138
I set it up to not request credentials.

Author Comment

ID: 26082216
I had to go back and create a  shared datasource from scratch.  That means deleting my datasource and everything.  and thus far everything is working.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Integration Management Part 2
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question