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

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

Rendering Reports in Reporting Services 2008 in Sharepoint Integrated Mode

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#

I have created a site collection using the Report Center template. I successfully deployed my VS2008 Reporting Servivces project to the Sharepoint site. However, when I goto the reports library and attempt to run a report I get "unknown error" message"

Also, I can create a dashboard consisting of one of my reports. However, when I attempt to view the reports via the dashboard, I get the following error message:

An error occurred during client rendering.

The target location you specified is not supported by the report server. A report definition (.rdl), report model (.smdl), resource, or shared data source (.rsds) file must be located within a library or a folder within it.

View Complete Post

More Related Resource Links

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?

Reporting Services Integrated mode 2008 R2 Subscription Email Error


I have setup report subscriptions delivered via email,  on Sharepoint and they tend to fail sending email randomly. It works most of the time, once or twice a week few subscriptions fail. Here is the detailed error message:

library!WindowsService_28!a74!05/18/2011-06:45:12:: w WARN: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. Logon failed for the unattended execution account. ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Log on failed. Ensure the user name and password are correct. ---> System.ComponentModel.Win32Exception: The security database on the server does not have a computer account for this workstation trust relationship

library!WindowsService_28!550!05/18/2011-06:45:12:: i INFO: Schedule 7d92afd5-f5ac-4d65-adc8-d87a3aa4bef4 executed at 05/18/2011 06:45:12.

schedule!WindowsService_28!550!05/18/2011-06:45:12:: Creating Time based subscription notification for subscription: 7f035fad-44a1-4cd6-9d41-5465540c879d

Reporting Services: Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration


The solution covered here includes a custom SharePoint Web service that accepts SQL Server-generated report files and, through the WSS object model, stores the file in the appropriate library for enhanced collaboration possibilities.

Ed Hild

MSDN Magazine March 2006

RDL Rendering (500 Internal Server) Error at Sharepoint Integrated Reporting Service


I have a serious problem that cannot be solved by googling around the keywords below:
sharepoint, moss 2007, reporting service, ssrs 2008, rendering, internal server error, ....

The error is;

"An error occurred during client rendering. The remote server returned an error: (500) Internal Server Error. "

Everything is O.K.;

* When I render the report from the REPORTSERVER (http://localhost/ReportServer)
* When the reports are scheduled to be sent by the reporting service (planned via MOSS 2007) 

But if I open (render) the RDL file from the sharepoint REPORTS LIBRARY interface, all of the reports fail with that internal error message above. 

It is weird also that parametrized reports are displayed without errors although the parameters are queried from a sql dataset. But I got the error when rendering the report after I've chosen a parameter  and order "apply/report"...

Possible causes how I met that error may be;

After I have installed (then uninstalled) AJAX extensions
After I have re-configured IIS Web Service Extensions list items

Possible solution alternatives I've found;

I've found a solution on MSDN replying a similar issue with an ideal cause of the error but an evreka answer but no sol

Excessive Deadlocking Reporting Services 2008 Integrated.

Hi, we have a major issue with deadlocking on our reporting Server TEMPDB (REPORTSERVERTEMPDB). The platform is a Sharepoint Integrated platform allong the following lines 2 WFE Servers (NLB) 2 Sharepoint application servers 2 SQL Reporting Services (NLB) Cluster hosting Sharepoint DB's Cluster hosting Reporting Services DB's and the Data. This error is occuring for both manually running reports via sharepoint and load testing, and is happening on our testing platform as well which is slightly different in configuration. Reported back to the users is "An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database" Running a profile with 1224 set, we are finding deadlocks on the REPORTSERVERTEMPDB on PK_SNAPSHOTDATA. We have tried the following 1. Dropping the PK - The deadlock was then showing an OBJID which we could not identify. 2. Change the database properties to READ-COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION to ON 3. Re-create and change the PK to ALLOW_PAGE_LOCKS OFF None have these have had an impact on the issue This has become apparent since the following actions were taken 1. The setting of caching has been enabled by the developers 2. The Report Server DB's were moved from the Sharepoint Cluster to the Data Cluster. I do have an XDL file from Profiler but it is to

Reports are not showing on management studio for SQL 2008 reporting services

I just did the side by side upgrade for reproting server from 2005 to 2008 and everything was fine. But when I login to the reporting server from management studio I am not able to see the report server folders like we do in SQL 2005. The only think i saw is jobs, security and shared schedules. I dont even see any jobs under this jobs folder. Do i need to do anything after the upgrade to be able to see the reports, subscriptions and data sources from the management studio? please let me know. Thanks!  kp

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.

Changing a current SQL 2008 Express Sharepoint instance to incl. Reporting services

I have a current instance of SQL 2008 Express that was created with a Sharepoint installation. Currently, that is the only purpose of the instance. We don't have management studio installed but from what we can tell by searching help screens is that instance is on SP 1 (10.1.2531.0) with Database Engine Services and SQL Server Replication. We need to now add Reporting Services. If we go to the Installation Tools to Add/Change the current instance, it asks for the SQL media which was from the original Sharepoint install. I have downloaded SQL 2008 Express with Advanced Tools but not SP 1. I've seen some threads where this wasn't a direct install. Ideally, I'd like to be able to change the current instance to add Reporting Services. When the wizard prompts for the media, will I be able to now point to the downloaed SQL Express w/ Adv. Tools even if it's not SP1? Thanks for your help. Tracy

Error while Rendering Reports(Reporting Services 2005) in .Net 1.1 web Application on IIS 6.0


I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or  something missing.

I have wasted so much time in a finding a solution and I appreciate any help in that.

Writing mode: vertical in Reporting Services 2008



I am new to Reporting Services 2008. I have a report from SSRS 2005. In that report layout, I modified text field's orientation to Vertical and set its writing mode as tb-rl. So, a field called [Report] displays  text vertically starting from R.

If this text is long say [Reporting services] it still displayed it vertically in one single line in SSRS 2005. But in SSRS 2008, It is appearing in two vertical lines. How can I get text in one vertical line?

Please advise.


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:

  • Report Manager URL http:///Reports is not working in SharePoint Integrated Mode


    Hello Friends,

    I am ali, I am so confused why the Report manager URL(http://<servername>/Reports is not working in sharpoint integrated mode. 

    In my local system

    1. at the time of SQL Server 2008 R2 installation Reporting services enabled In Native mode.
    2  In Reporting service config manager tool http://<serverName>/Reports URL is working in Native mode. Here i am able to create New Roles.
    3. In Reporting service config tool When i create a new database in sharepoint integrated mode, the the Report Manager URL http://<ServerName>/Reports not working, gettig this error "This operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode)"
    4 . From both databases(In native mode and sharepointmode) the the webservice URL http://<servername>/ReportServer working fine.

    Reporting Services Config manager :

    Installation of SSRS 2008 in SharePoint integrated mode

    Hi All,

    I have got a server (Windows Server 2003 x64) which has the Office SharePoint server 2007 and SQL Server Reporting Services 2008 (in SharePoint Integrated mode) installed in a stand-alone machine (System configured and installed by some other guy). We want to use the SSRS 2008 in SharePoint integrated mode.

    I want to make sure that installation and configuration of system is done properly. But i am a starter, so i don't know much where to start.

    Please help me which points i have to check to make sure that system is configured properly.

    Also i visited the server and found the followings:
    1. In central administration, under Application Management tab, Report Services section is not there. ( I think SSRS 2008 AddIn is not installed)
    2. Single MSSSQLServer is created for SQL Server 2008, SSRS 2008 and Office SharePoint Server 2007 (Not sure Please let me know where i can confirm this)

    Any help is appreciated.


    Thanks, Cool Developer

    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.

    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!

    In Sharepoint Integrated Mode whether Report Manager URL http:///Reports will open the


    Hai Friends,

                    I am Ali, In SharPoint Integrated mode ReportManager URL getting This Error [ This operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode) ].

    1. at the time of SQL Server 2008 R2 installation Reporting services enabled In Native mode.

    2  In Reporting service config manager tool http://<serverName>/Reports URL is working in 'Native mode' as Fine. Here i am able to create New Roles and able create New Folders and able to deploy the Reports from BIDS and Report Builder to Report Server.

    3. Now , I opened Reporting Services Config Manager Tool and I Created New Data Base(as 'ReportServerTest) In sharepoint Integrated mode.

    4. ReportServer Configured Reporting Services in SharePoint Integrated mode Sucsessfully. Granted Data base.

    4. Enabled Content Types Sharepoint Library and i am able to deploy .rdl files from BIDS(Designer) to sharepoint library.

    5. But i need to Deploy the Reports from Report Builder 3.0 to Report Server In SharePoint Integrated Mode

    I Want to op

    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


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