Solved

Sharepoint Report

Posted on 2013-01-21
2
640 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 500 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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

679 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