.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 Integration with SSRS

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint

When you install SSRS as sharepoint 2010 integrated are then able to create reports using data (lists) from sharepoint?   Currently I use access/excel to make more advanced SSRS type reports with logic.   I know you can do it directly on Sharepoint with VS, but I just need quick and dirty ways to do it that I can teach to others quickly.


View Complete Post

More Related Resource Links

How to add SSRS Integration to an existing SharePoint 2010 farm


Note to Administrator: this post is regarding SharePoint 2010, but I was unable to select 2010 for the forum when creating the thread.  Please feel free to move it to the appropriate forum.

pre-2010 Moderator Note: I don't understand why not. Please in a later post add a paragraph with how you created the thread.

I've found some instructions on TechNet for configuring SSRS Integration with SharePoint 2010, however they all assume you are starting from scratch.  I have a production two-server farm up and running: a web front end and a database server (SQL 2008 R2).  Reporting Services is enabled and the SP-Integrated database created on the SQL server.

I tried installing the WFE bits on the SQL server and adding the server to the farm, but I encountered errrors trying to add it to the farm.  Does anyone have instructions for adding SSRS Integration to a production farm?

SSRS 2008 R2 running in SharePoint 2010 Integration mode - Not able to schedule reports.



I am unable to schedule report am getting following error when trying to schedule an SSRS report from ReportViewer Webpart in SharePoint 2010.

  • The current action cannot be completed. The user data source credentials do not meet the requirements to run this report. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)

I have SSRS 2008 R2 running in SharePoint 2010 Integration mode on Win 2008 R2 System.

I have also setup the unattended execution account from the Reporting Services Configuration Manager, which has appropriate privilates on the database to generate report.

Also, I have reporting webservice setup @ following url (am using the named instance of SQL Server):


Am able to view the report from report viewer webpart but unable to schedule it.

Kindly let me know what's going wrong.

Thanks in Advance,

Sachin R. Chavan.

Sachin R. Chavan.

Video: SharePoint 2010 Integration with PowerShell

Learn about the new PowerShell integration in SharePoint 2010, which brings SharePoint administration in line with other server products such as Exchange. Understanding PowerShell is a must-have skill for SharePoint 2010 developers. (Length: 19:52)

Facebook integration with sharepoint 2010

how can I show my facebook posts in sharepoint 2010?

Sharepoint 2010 Business Intelligence integration with datasources other than MS SQL Server

I want to Implement Business Intelligence by SharePoint 2010 on top of data sources other than MS SQL Server or MS Analytics Services ( cubes ), for example Oracle RDBMS and Oracle OLAP ( cube ) or Teradata. Quesiton : Is there any way to do this, if the is, how do I bring metadata to sharepoint BI or how do I make SharePoint BI to see other data source. I've looked at Busines Data Connectivity in Visual Studio, but that is more for two way integration and didn't seem like a good or easy way just to bring new data sources to SharePoint BI I found some tool from third party company "BDC Meta Man" which created metadata layer for Oracle RDBMS in SharePoint, but I thought there must be a way to do it by using Microsoft tools

Sharepoint 2010 integration with Office 2010, 2007,2003

hi, i am looking, if some one know about the details or link, for the details about the Sharepoint 2010 integration with Office 2003, 2007 and 2010 versions. We will be migrate in couple of months to 2010 but we have mixed flavor of the office version in our environment. We have 2003, 2007 and 2010. Is their any blog post or anyone know what is now possible with 2010 but not in the 2007 or 2003. like a comparison chart.   thanks WSi am at entry level administrator

Integration of Windows live Id authentication with Sharepoint 2010?

Dear folks,   please give me some details about Integration of Windows Live Id authentication With SharePoint 2010? Thank you Regards Immanuel c

SharePoint 2010 AD FS 2.0 Integration - login works then fails, looping back to the adfs server

Hello, I setup SharePoint 2010 Claims auth with AD FS 2.0 following this post: http://blogs.technet.com/b/speschka/archive/2010/07/30/configuring-sharepoint-2010-and-adfs-v2-end-to-end.aspx.  I have no access to the ADFS server, but I think they followed the steps as outlined.  If I do an iisreset (or just recycle the app pool of the SharePoint site) I can login successfully using the remote credentials.  Also I can under security in SharePoint search for and find users and roles from the remote ADFS server. If I close my browser, open a new browser and go to the site I am prompted to login again (this is fine).  I do, using the same credentials, and the login fails because I am redirected between the SP and ADFS servers until the ADFS server stops the redirecting.  I have been doing some digging and I found this post: http://blogs.technet.com/b/speschka/archive/2010/08/09/setting-the-login-token-expiration-correctly-for-sharepoint-2010-saml-claims-users.aspx, which describes the situation I have in point # 3 at the bottom.  I have tried setting the token time out as low as 1 second but this hasn't helped. I have also, just to see, tried setting all the other lifetime settings to 1 second - but no luck.  Because the initial login works I think the setup is correct, but something is maintaining some state that is causing the loop

How to pass current user's login name as parameter to a RDL . (SSRS integration with sharepoint)

I have a webmethod which has two parameters. One is for year and another is for Currently logged in user. I call this method in RDL file. From RDL File how can we pass Currently logged in user's login name? I tried  with USER!UserID. It is passing the USERID but i need to pass the login name(SPWEB.currentuser.loginname)  

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

Office Integration with SharePoint 2010

Hi,   Can you please provide me a presentation which talks about Integration of different Office Suites with SharePoint 2010.   Regards, Garima

Parameter value filter based on user in SSRS (SharePoint Integration mode)


Hello..we have a reuirement where we have to filter the parameter value in the drop down based on the user who is accessing the report. We have form and Windows authenication enabled in the SharePoint site (some users will be from inside the network using windows and some will be accessing the site using internet using the Form Authentication).

Please let me know what would be the best way to handle this reuirement? Do we need to create a separate table  and store the User Information along with the parameter values they have access to, pass the userid from Report to db and then fileter the records using this table? OR Can we create a SharePoint List to maintain the user access information and then directly fetch the user information from the list using T-SQL to filter the records?

Please let me know your suggestion...


iSeries & SharePoint 2010 integration

Is anybody has an idea about the compatibility & feature to integrate iseries (db2) data with SharePoint 2010. I had a very hard time to find the solution in SharePoint 2007. I am hoping there should be more option in SharePoint 2010.

SSRS R2 w SharePoint 2010

I've installed and configured SSRS 2008 R2. I used configuration manager to configure in SharePoint integrated mode - but the Current Report Server Database/Report Server Mode setting in config manager shows "Native". I expected to see Integrated. Did I do something wrong? Also, what is next? How do I tell it which SharePoint front end to associate with?

Looking for guidance: Integrated SharePoint SSRS migration and upgrade from 2007 to 2010


Our existing prod farm is MOSS 07 with an integrated SSRS instance using SQL Server 2008, both on Windows Server 2003 64bit boxes. SharePoint databases are on a different SQL Server 2008 server.

I have built a new SharePoint 2010 farm on Windows Server 2008 R2 boxes, using a single SQL Server 2008 R2 Enterprise server as the backend for both SharePoint databases and Reporting Services (installed in Integrated mode). We are going to be using the database-attach method of upgrading our SharePoint farm.

Is there any specific guidance out there on exactly how to migrate/upgrade Reporting Services in this scenario? I've read through some of the MSDN content (How To: Migrate a Reporting Services Installation) but nothing seems to deal specifically with doing this when in Integrated mode with SharePoint. Our business heavily relies on SSRS reports in SharePoint and also shared and custom report subscriptions via email.

We do have a dev SharePoint 2010 farm in a similar configuration that I can test migration/upgrade steps. Thanks.

AAM Problem with SSRS 2008 R2 and Sharepoint 2010


I have a single server farm with Sharepoint 2010 and SQL 2008 R2 installed. I have an extranet zone configured - and this is working fine from the internet via a Forefront TMG box.  All features in the farm, including Performance Point pieces (reports/dashboards etc) are working fine via the extranet zone except for Reporting Services reports (these are working fine in the internal/default zone).  I can see the report library, and the individual report items via the extranet, but when I try to view a report, I get this:

" The Web application at https://extranet.company.asia/client/Report Library/Spend by Media Owner.rdl could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application."

My understanding is that multiple zones are now supported in Sharepoint 2010/SSRS 2008 integrations, and that AAM should propagate automatically (?).  Can anyone assist in helping me understand where to look next?

many thanks,


SSRS Report Viewer WebPart dynamic dispaly in SharePoint 2010


dynamic layout or zone  for Report Viewer Webpart, the report as to take all the space possible, and I don't want the scroll bars.

Any Suggestion

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