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


Top 5 Contributors of the Month
Imran Ghani
Post New Web Links

Sharepoint 2010 & Report Server Web part

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :SharePoint
 

Hello all,

I'm doing some test integrating Sharepoint 2010 with Reporting Services.

My farm (a single server installation) is :
Sql Server 2008 R2
Sharepoint 2010 Enterprise

I've correctly set up the integration and all is working fine with simple reports.

With report with parameters or a little more complex I have a Js error stating this :

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; InfoPath.2; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; FDM; WWTClient2; .NET4.0C; .NET4.0E; InfoPath.3)
Timestamp: Tue, 5 Oct 2010 13:58:56 UTC


Message: Sys.ArgumentNullException: Value cannot be null.
Parameter name: panelsDeleting[1]
Line: 4723
Char: 21
Code: 0
URI:
http://<SharepointServer>/ScriptResource.axd?d=6iEBSFYsoVA_iKoRgiGHAUV4efTTyw2zxZBwHuMEIY394eHtYQmQ0lNxBCUnQ9Mz5is


View Complete Post


More Related Resource Links

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

  
Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

Report Builder 3.0 unable to access SharePoint Foundation 2010 Report Server

  

I am having a terrrible time getting this to work. I have configured the SharePoint site and the SQL Servers involved to use Kerberos. That has been confirmed working.

I then configured the SharePoint site's Reporting Services integration (trusted account), enabled anonymous access and enabled report builder. I can launch report builder without any issues at all. The problem comes when I try to save my report. When Report Builder is started Items->New-ReportBuilder Report it opens and display in the lower left hand corner "No current report server." When I close the Wizard dialog and click connect I enter http://server.fqdn.net and I receive the following error:

Connection failed:

Unable to connect to the server that is specified in the URL, 'http://servername.fqdn.net/'.

Make sure that the server is running, the URL is correct, and you have permission to use the server.

I have also tried http://servername.fqdn.net/reportsserver/. When I try that I receive a login prompt. When I enter my credentials it tries for a few seconds and then sends another login prompt. I installed the report server using default settings. The reporting services db is on the same server as sharepoint. The configuration and other databases are on a remote S

SharePoint 2010 Security (Prompts for Login) Issue with SSRS report with Out of Box Web Part

  

Hi All,

I have a SSRS Customized Report (.RDL). I have a web part with association on one of the report. When I try visit the page I am prompted for credenatial.

My Data Source Properties are as per below

Use this user and Password

  user name: domain\myadminuser

  password:****

Selected: use as win auth

Selected: Impersonate

 

How Can I get rid of prompt?

 

 

 

 


Pathik

SharePoint 2010 Security (Prompts for Login) Issue with SSRS report with Out of Box Web Part

  

Hi All,

I have a SSRS Customized Report (.RDL). I have a web part with association on one of the report. When I try visit the page I am prompted for credenatial.

My Data Source Properties are as per below

Use this user and Password

  user name: domain\myadminuser

  password:****

Selected: use as win auth

Selected: Impersonate

 

How Can I get rid of prompt?

 

 

 

 


Pathik

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

  

Hi,

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


CRM 4.0 List Web Part for SharePoint Server 2010 Installation Error

  

From the "Requirements" for this web part (link below) I should be able to install it (my environment includes server 2008 R2, CRM 4.0, and SP 2010. I am getting an error "Setup could not be completed. Try launching  from the administrator Command Prompt using msiexec /i ...." Has this web part been installed on Server 2008 R2 or is it only for Server 2008?

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=3B6EB884-EC15-4288-A2A3-D0B47E057458&displaylang=en

 


David

Configuring SharePoint Server 2010 Search for External Content Types, Part 2

  
Learn how defining external content types reduces crawl times for large amounts of data by using incremental crawls.

Configuring SharePoint Server 2010 Search for External Content Types, Part 1

  
Learn how to use SharePoint Designer 2010 to define external content types and to set up a SharePoint Server search crawl that includes that external data.

Content Query Web Part missing in SharePoint 2010

  
If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

Accessing SharePoint 2010 Data with Server-Side APIs

  
Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Configuring User Profiles in SharePoint Server 2010

  
Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

Office Services: Merging Word Documents on the Server Side with SharePoint 2010

  

Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010


Cannot export from a Report in SharePoint integrated mode in a server hardend environment

  

We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.

The environment has worked fine in test (but the servers are not hardend).

With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.

There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)

When the report is opened directly from Reporting Services (ie http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue only happens when the report is invoked directly through SharePoint.

 

We can only assume that this issue has something to do with server hardening/UAC as we have

Sharepoint 2010 power tools visual sandboxed web part issue!!

  

Hi guys

I tried to use a simple hello world web part with with sharepoint power tools the solution is added ok but when I try to add the web part to the page I get this error "Unable to load assembly group. The user assembly group provider...." Any thoughts

Regards

Rodolfo

 

 


rsoares

SharePoint Enterprise Search Migration Tool for SharePoint Server 2010

  
Use this tool when you upgrade to SharePoint Enterprise Search to migrate search-related data, such as best bets, search scopes, and site collection search settings.

Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

  
Learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010 to read and write data to the AdventureWorks sample database.

Sample: Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

  
Explore the code in this visual how-to article as you learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010.
Categories: 
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