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


Top 5 Contributors of the Month
Sandeep Singh
Melody Anderson
Sharad
Eminent IT
Post New Web Links

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

Posted By:      Posted Date: November 03, 2010    Points: 0   Category :SharePoint
 

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




View Complete Post


More Related Resource Links

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


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

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

  

Hallo,

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/Explorer webpart for SSRS Native Mode

  

Guys,

I have created a simple report with BIDS and have deployed to my SSRS server. Works fine... when I use the Report Viewer/Explorer webparts it works fine only on my PC. Really only displays on my computer. When others access the page the webpart does not load... it states "Navigation to the webpage has been cancelled." I have added all necessary permission to the report. the report displays if users access it directly from the report server, just not when viewing from the Sharepoint site. I even logged into another computer with my domain credentials and it did not work only on my computer that i used to create/deploy the report with BIDS...

any help would be great I'm stumped....


How to import SQL Server Reporting Services Report Viewer Webpart on web part Page using code in Sha

  

Hi Every One,

I have use SQL Server Reporting Service in SharePoint integrated mode. I have deployed all reports and data source in SharePoint Document Library using CODE. I need to show those report in “SQL Server Reporting Services Report Viewer” Web Part on Web Part Page, I have created Web Part page by code. But I cannot import this Web Part on Page using Code.

How I can do this by code.

 


Navaratan Sharma

Add SQL Server Reporting Services Report Viewer webpart on SitePage give error.

  

hi

i have use Sharepoint Foundation 2010 with VS 2010. i have config  in Reporting Services 2008 R2 SharePoint integrated-mode. when in add  SQL Server Reporting Services Report Viewer webpart  on SitePage it give error message. "The Controls collection cannot be modified becouse the control contains code blocks(i. e. <%...%>)." How i can add this web part on my SitePage?


Navaratan Sharma

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

Redeploying Customizations and Solutions in SharePoint Foundation 2010 and SharePoint Server 2010

  
Learn how to redeploy customizations and custom solutions that you created for Windows SharePoint Services 3.0 and SharePoint Server 2007 in SharePoint Server 2010 and SharePoint Foundation 2010.

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?

Sharepoint Foundation 2010 to Sharepoint Server 2010

  
Hi there, We have Sharepoint Foundation 2010 already installed on Windows Server 2008, which uses SQL Server 2008 R2 Express (64 bit). There are sites already created and Custom lists and workflows. We then purchased a Sharepoint Server 2010 license. Is there an easy way to upgrade our current sharepoint using the same Database (Content DB). How do I deploy this new Sharepoint (on top of the Foundation) Worst case scenario: I have to remove Sharepoint Foundation and then install the licensed "Sharepoint Server 2010" version Please advise

SharePoint 2010 Reporting Services report on sharepoint list rsExecutionNotFound

  
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

Upgrading to SharePoint 2010 Foundation on SBS Server 2008

  
Hi all, I've just tried to install SharePoint Foundation on 2010 on Windows Small Business Server 2008 and whilst the literature I've found suggests that this is supported, I receive the following error: SharePoint 2010 Products cannot be installed in Stand-alone mode on a Domain Controller.  For more information on upgrading, see http://support.microsoft.com/?kbid=975805. What's funny about the KB ID, is that it doesn't exist.  The pre-requisites for SharePoint 2010 Foundation installed OK and the SharePoint installer has detected that it will perform an in-place upgrade.  the STSADM -o preupgradecheck output is below. Any idea's?  It would be really great if we could start using the shared workspace and ribbon features that are inherent with SPF2010. Jason.  

Problem with Report parameter inside SSRS Report Viewer webpart with deployment from one server to a

  
Hi all,I've got this problem.me and my team have developed a lot of reports by using a SSRS configured in Sharepoint Integration Mode.For accessing these report we are using the Sql Server 2008 Report Viewer Webpart.One of its parameter is the Report ur that is an absolute url so the problem is when I move our solution from server1 to server2 I have to re-editing all pages where I've added the Report Viewer webpart for updating the report url with the new servername otherwise it's impossible to view the report.Is there any official or unofficial way to solve this problem ?many thanks

Visual Studio 2010 can't find the Sharepoint Foundation 2010 Server when compiliing, Standalone vs

  
I'm wondering if we installed Visual Studio correctly cos when we get into Visual Studio 2010 the "Deploy as a Farm Solution" is the only available button option and the "Deploy as a Sandbox Solution" is un-selectable, grayed out, assuming the "Sandbox" solution is the "Standalone" approach? So when we go to compile a Workflow, the error message says the Sharepoint Server is not found" Could this "Deploy as Farm Solution" be a problem when we were instructed to install Sharepoint 2010 Foundation as a "Standalone" install? in other words we're trying to find out why when we go to compile a Workflow in Visual Studio 2010 that it can't find the Sharepoint Server Step 3: Install SharePoint 2010 1.  To install SharePoint Server 2010 or SharePoint Foundation 2010, open a Command Prompt window, and then type the following at the command prompt: On the Choose the installation you want page, click Standalone to install everything on one developer workstation. Thanks very much for any suggestions, ideas or pointers! BobK

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.
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