.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SharePoint 2010 Reporting Services report on sharepoint list rsExecutionNotFound

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :SharePoint
I cannot get SQL Reporting Services 2008 R2 to work with a datasource that is a sharepoint list.  Reporting services seems to work fine setup in SharePoint 2010 Integrated mode. When I try and run a report that is based on a sharepoint list, I immediatly get the following error: The report execution tp15sp4515l3seqqo4do3e45 has expired or cannot be found. (rsExecutionNotFound) This seems to be something I am doing wrong with the sharepoint configuration, I would guess.  I haven't tried a regular database query, but they used to work when reporting services was configured for native mode.  So I assume this is just a problem connecting to sharepoint 2010 lists, with the new SharePoint 2010 List connection type. Edit This has got to have something to do with a permission setting for the app pool account of sharepoint.  I read something once where it said you had to grant it permissions, but every guide I've found since then doesn't mention anything about it. This log entry is where the problem seems to be occuring, I just don't know what permissions to give TESTDOMAIN\spweb which is the app pool account. library!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, tim

View Complete Post

More Related Resource Links

Sharepoint 2010 Standard Edition Custom List Reporting Using Report Builder 3.0


hi, i'm making this report from a sharepoint list. i want to add some of the fields as the parameters for the report. (e.g : Category, Department)

i tried to run the report, the parameters were shown as expected

but the problem is when i create a query in the dataset.

i'm using caml query builder for the query expression. it goes like this :

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ListName>IT Helpdesk</ListName>
    <FieldRef Name="Employee_x0020_Number" />
    <FieldRef Name="Title" />
    <FieldRef Name="Department" />
    <FieldRef Name="Category" />
    <FieldRef Name="Time_x0020_Spent" />
    <FieldRef Name="INT_x0020_Time_x0020_Spent" />
    <FieldRef Name="Severity_x0020_Level" />
    <FieldRef Name="Ticket_x0020_Source" />

How to prepare a report using Sharepoint List data in Reporting Services



I have to prepare a report using the data in sharepoint list i.e., data which would be exported to excel when we click in action tab of sharepoint list. I found most the websites answering how to prepare a report using sharepoint list as datasource. But I want to use the data "IN" sharepoint list as my datasource. I really appreciate your quick response..!!






SharePoint and SQL reporting services. Report of access?

Hello,Can a report be created with SharePoint and SQL reporting services that shows who has accessed the document and when?Thanks in advanceSebastian  

Problems with Report Services 2008 Integration in Sharepoint Foundation 2010

hi Folks, i ihave tried to solve my problem with this entry, but it has not fixed the issue. I would like to integrate RS in a Sharepoint Foundation 2010 environment, but when try to integrate the RS in Central Administration I am receiving the following error, see pic: Central Administration jpg When I try to access direct the RS Url the I get an access denied error please help.   thx a lot

SharePoint 2010 Reporting Services Integrated-mode Error

I am running SharePoint 2010 and Reporting Services 2008 R2 SharePoint integrated-mode. I am able to browse to the reportserver site : http://DBserver/reportserver which lists my site collections and I am able to get to the document library which holds my reports. However, when I try opening a report I get the following error: Report Server has encountered a SharePoint error. (rsSharePointError) The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again. For more information about this error navigate to the report server on the local server machine, or enable remote errors I am able to resolve that issue by going to Central Admin, Application Management, General Settings and turning Web Page Security Validation Off. But if I do that I get an error when using silverlight features like site, or list creation. Any ideas?

Windows Sharepoint Foundation 2010 - Document Library Settings with Reporting Services 2008 R2 in in

I have a client who has recently upgraded their SharePoint system to Windows Sharepoint Foundation 2010 with Reporting Services 2008 R2 in integrated mode. I have configured reporting services and am able to deploy reports to SharePoint. The client created a document library before the upgrade to WSF 2010. I need to add Report Builder 3.0 to the New Document menu and found the following article. http://technet.microsoft.com/en-us/library/bb326289.aspx "Allow management of content types?" is set to yes under the advanced document library settings. The problem is that when I try to "add from existing site content types" the reporting services content types are not in the list. I appreciate any help you can give me.

I get a rsUrlRemapError when trying to display Reporting Services report in SharePoint



When I try to open/view a report in SharePoint I get this strange error:

The URL, 'http%3a%2f%2fdemo%2f_vti_bin%2fReportServer', cannot be mapped to a public URL in this SharePoint environment. (rsUrlRemapError)

It seems like the URL get encoded somwhere, but where and why??

Everything else seems to be ok. The report renders well when navigating directly to it (not using the Reporting Services web part).

(SharePoint 2010 RTM)



report from multiple list in sharepoint 2010



I want to create report from multiple list in sharepoint 2010. In general Sql Server Business Intelligence,allow create report from 1 list.

how i can create report from multiple list with Sql Server Business Intelligence?


SharePoint 2010 and Reporting Services 2008 R2 Integration Fail - Failed to establish connection wit


We have installed SQL Server 2008 R2 Standard Edition on a virtual server (C-SQL) and SharePoint Server 2010 on another virtual server (C-SPOINT), with the SQL Backend of the SharePoint database residing on C-SQL. This worked fine.

SQL Server was installed with the domain administrator account and SharePoint with an account called 'visi' that has domain administrator privileges.

SSRS on C-SQL was initially installed as a native database. I changed this to a SharePoint integrated database with all authentications done as the visi user. Report server url was set to the normal http://C-SQL:80/ReportServer/.

On the SharePoint central administration site under General Application Settings -> Reporting Services Integration I filled in the details as required:

  • Sharepoint Server 2010: Reporting Services Integration - 401: Unauthorized


    Hi everybody,

    I know - there are lot's of articels, posts, etc.. about configuring Reporting Services in Sharepoint 2010 and I feel like I read them all hundred times at least... but none of them helped me solving my problem.


    I have the following Scenario at a customer:

    Servername / Functionality

    db01 / MsSQL 2008 R2 server (also contains the ReportServer DB - of course it's type is Sharepoint Integrated)

    app01 / Sharepoint 2010 Server (Complete Installation) - used as Indexing Server and running some other Service, Central Administration, Reporting Server

    *fe01 / Sharepoint 2010 Server (Complete Installation) - used as Frontend Server

    *fe02 / Sharepoint 2010 Server (Complete Installation) - used as Frontend Server

    *member of Windows NLB


    I configured Reporting Services Integration in Central Admin and everything worked perfectly correct - no errors - strike!.

    But now comes the "funny" part:


    If I open a Report on a Sitecollection like http://app01:1234/ the report is getting rendered and presented - yeah!

    But if I open a Report on a Sitecollection like http://NLB-URL/ the report throws an error (damn!):

    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    SharePoint 2010 & Sql 2008 Reporting Services Integration


    Need a little help.  Here is the error message I recieve when trying to add the Reporting Services URL in Central Administration

    Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages

    Here is the report from the Log.

    10/20/2010 14:31:56.58  w3wp.exe (0x0B6C)                        0x05E8 SQL Server Reporting Services  Configuration Pages            aabe Medium   RS configuration object updated with RSServerUrl=http://sql2/ReportServer, AuthenticationType=Windows 58bcdd3b-13e9-4bd7-8008-718e5fd7202a
    10/20/2010 14:31:57.61  w3wp.exe (0x0B6C)                        0x05E8 SQL Server Reporting Services  SOAP Client Proxy              0000 High     Exception encountered for SOAP method GetSystemProperties: System.

    SSRS Report Sorting issue in Dashboard created usign Performance point services in sharepoint 2010


    I have created a report in SSRS and this report is integrated within a dashboard created using performance point services in sharepoint 2010.

    The report is a simple tabular report with 5 coulmns and interactive sorting is enabled on each of them.

    Sorting works when the report is viewed separately but gives "Report Server Error" when I try to sort (on any column) inside the dashboard.

    I have user IP instead of host name in the report server url.

    Please help.



    Reporting services and Sharepoint Foundation 2010 + SQL Server 2008 R2 RTM - Express with Advanced S



    is possible use reporting services in Sharepoint Foundation 2010 if I have installed SQL Server 2008 R2 RTM - Express with Advanced Services? I tried various settings and configurations, but it not works (I am not able successfully configure Reporting Services Integration in Central Administration).

    Now I am not sure that is possible use reporting services in SPF 2010 + SQL Server 2008 R2 RTM - Express with Advanced Services...

    Thank you!

    Report viewer webpart in sharepoint 2010 foundation with Reporting server in native mode, possible?



    We have a product on sharepoint 2010 whose major feature is with the reporting services, we are checking to see if our product can be deployed in a minimum environment of sharepoint 2010 foundation.
    we have a minimal test environment with the following :

    windows server 2008 R2
    SQL Server Express Advanced
    Reporting services configured in Native Mode
    Sharepoint 2010 Foundation.

    I would like to know if we can enable report viewer webpart on sharepoint foundation 2010 with the reporting services in native mode. our plan is that even if the reporting services are not in sharepoint integrated mode, we are thinking of using web services to get XML data and using the XML data in report builder 3.0 to generate reports? will the idea work in this environment? if so can anyone let us know how to get the report viewer web parts in this environment?

    Thanks for any help,

    - Asif

    Reporting Services 2008 and SharePoint 2010


    I have Reporting Services 2008 and it is not configurate yet, we will buy SharePoint 2010, but we need to begin to work now with Reporting, can I configurate Reporting before SharePoint and when we have SharePoint, I can reconfigurate Reporting? or we can wait for SharePoint



    Where can I view the Reporting Services apart to Report Viewer and Sharepoint?


    Hello Guys,

    Someone know if  can I add a report server on Jboss Portlet or other service web?, I have a Portal of JBoss technology and I'll want to add in a portlet the reports that I made in Reporting Services and Analysis Services, but I ignore if could this is possible?

    I'll appreciate any information about that. Thanks a lot.



    Sukey Nakasima

    Sukey Nakasima

    Making a report with hyperlinks: Reporting services and Sharepoint Libraries


    Hi There,

    I want to build a report using reporting services with BIDS with a sharepoint document library as Data Source. This isn't a problem, but that I am not able to do is create a report with hyperlinks to the documents stored in the sharepoint library mentioned, so the user may click on the links to open the document in their native application (word, acrobat reader, outlook...)

    Any one knows how to do it?


    Thanks in advance and best regards,


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend