Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sharepoint Report

Posted on 2013-01-21
2
Medium Priority
?
676 Views
Last Modified: 2013-01-25
I created a report with SQL Server Business Intelligence Development Studio and uploaded it to a sharepoint 2010 foundation document library.

It works greate if someone with Sharepoint Full Control premission tries to open it.
But, it does not work if anyone else EVEN domain admins try to open the report. It returns this error:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
List 'Phonebook' does not exist at site with URL 'http://servername/subsitename'. (rsSPDataProviderError)
0
Comment
Question by:pauledwardian
2 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 2000 total points
ID: 38802964
Hi,
can you verify that the data source is configured and approved/published for the report?

HTH
Rainer
0
 

Author Closing Comment

by:pauledwardian
ID: 38820342
Got it!
0

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

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

963 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