.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

Reporting Services Chart in SharePoint Web Part, Broken Image Problem

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :SharePoint
 
Hi,
I have a reporting services report that displays a dundas chart, it is a snapshot report executed daily.  When displaying the report inside a page viewer webpart or a report viewer web part in SharePoint, the first time after a recent snapshot occurs, the image shows up broken.  On refresh of the page the image is visible.

MOSS 2007
SQL Server 2005 Reporting Services NOT running in SharePoint Integration mode.

Any ideas or work arounds to get the image to display on the first load of the page or why the image is broken?  I've tried different report parameters, Format, ClearSesson with no luck.  Viewing the report in Report Manager works fine and also going directly to the ReportServer page is fine.  It only occurs when it's inside of SharePoint inside of the Page Viewer or Report Viewer web parts or even if I manually create an iframe in a content editor web part.

Thanks!


View Complete Post


More Related Resource Links

Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint

  
Hi,

I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies



Any help will be very appreciated!

Thanks,
-Raj

Problem Deploying the Reporting Services Web Parts to SharePoint

  

Hi,

I am trying to install the RSWebParts.cab file - which contains the Report Viewer and Report Explorer web parts - to my SharePoint 2010 server.  I ran the following command in PowerShell: stsadm -o addwppack -filename path/to/RSWebParts.cab -globalinstall. And received "The solution was successfully deployed" message.

However when I go into the SharePoint Server web front-end, I cannot find any trace of the new web parts.  Going back into PowerShell I ran the Get-SPWebPartPack command and the following was returned:

Name                             SolutionId                                                Deployed

rsswebparts.cab               00000000-0000-0000-0000-000000000000    False

 

So it appears to me that the cab file was loaded but not deployed.  But I'm not sure what I need to do next in order to get this pac

Problem integrating SharePoint with Reporting Services across different servers using Kerberos

  
Hi Folks

Apologies for the long post but wanted to include as much detail as possible...

Edit - Sorry just realised I hadnt mentioned we are using SQL Server 2005 SP3

We have a problem with our SharePoint Reporting Services integration, we are using Kerberos authentication and our SharePoint installation and SQL Server databases are on separate servers.  I have listed details of our setup below and also the symptoms we are experiencing....

 

Setup details

 

ServerA (SharePoint Server) Windows Server 2003 R2 Enterprise x64 Edition SP2

 


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


Web Parts: Use Windows SharePoint Services as a Platform for Building Collaborative Apps, Part 2

  

Microsoft Office SharePoint Portal Server 2003, which is part of the Office System, lets you create and manage virtual servers, site collections, sites, workspaces, and users. You can also use the Windows SharePoint Services object model to design and implement user-targeted applications. In the second part of a two part series, the authors take a look at the WSS and SPS object models, Web Part Page anatomy, creating and deploying Web Parts, and Web Part security. They also discuss Web Part infrastructure and how to create custom Web Parts.

Jason Masterman and Ted Pattison

MSDN Magazine August 2004


Reporting Services in SharePoint integration - configurtion errors in 64bit version

  

Hi,

We have build an MOSS 2007 environment on 64 bit servers. We build the reporting services server and configured in SharePoint integration mode. Initially configuration looks fine with reporting services integration with green indicators.

 

After creating a web application and accessing the web site from the report servor, i have found the following errors:

 

Server Error in '/' Application.
--------------------------------------------------------------------------------

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'RSSharePointSoapProxy, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot fi

SharePoint Calendar Error: The "ListViewWebPart" Web Part appears to be causing a problem. Index was

  
In one specific SharePoint calendar, on one specific week in that calendar when we select the "more items" link in the monthly view (or the expand all option) we get the following error:
The "ListViewWebPart" Web Part appears to be causing a problem. Index was outside the bounds of the array.

Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
Troubleshoot issues with Windows SharePoint Services.

If we select a different week the expand and collapse works fine in that calendar.

Reporting Services and Sharepoint Integration - Sharepoint Alternate Access Mappings (Zones)

  
I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone: System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. Is this a limitation of the SQLRS-WSS3 integration or is there a workaround? Many thanks to anyone who can help!

reporting services xy scatter chart with three data series

  
Hi, I have a report that includes an XY scatter chart with three data series.  Two of the data series are + and - tollerance bands and the thrid data series is the test points.  The data displays in the graph but I only seem to be able to get all three series to display as a line or all three to display as data points.  I need the tolerance bands to be a line and the test point to be displayed as data points without a line joining them up. Please can you provide a solution.   Thanks

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Problem Integration SQL Reporting Service 2005 and SharePoint 2007

  
Hello, I'm trying to make our SQL Reports available on our SharePoint report center. I have SQL 2005 (sp3) report server that resides on a different server than our SharePoint 2007 server. So in our SRS Configuration Tool, we changed the database mode for SharePoint integration (before, we only had it in native mode), so we created a new database for this SharePoint Integration type. Next, I installed the Report Server Add-in for SharePoint 2007 server and it was successful. However when configuring the Report Server, we got stuck at the step "Grant Database Access". For some reason we keep getting error message "Named instance not found" We already installed Service Pack 3 on the Report Server... I heard that the problem is because the mismatched version between the Report Server Add-in in SharePoint and the SQL RS version... but I don't think this is the case for us. Do we need to install WSS on our Report Server too?     Another question: We already integrate our Report Server with Microsoft Dynamics CRM 4.0. However I see that when the Report Server is in the SharePoint Integration mode, all the reports in CRM don't work (because Report Manager is no longer available in this mode). Do you think it would be the best practice to install a copy of Report Server instance in our SharePoint 2007 server? Thank you, greatly appreciate all your hel

Custom Web Part Problem After SharePoint Restore

  
Hi, I've recently moved our sharepoint site and databases (using Microsoft Internal Database) to another standalone server. I did a catastrophic backup and then restored it on the destination server successfully via the central Administration page. I have also copied our custom web part library dll to 'c:\windows\assembly' directory and 'C:\Inetpub\wwwroot\wss\VirtualDirectories\80\bin' directory. I also copied over the old web.config file to 'C:\Inetpub\wwwroot\wss\VirtualDirectories\80'. However, I still seem to be missing something as I get the error below while loading the site. I haven't been able to find a solution so hoping someone has seen it before here. Has anyone seen this happen before? Any advice/help would be greatly appreciated. Many thanks. Mehds ERROR====================================================================================================== The “webpartname” web part appears to be causing a problem. Object reference not set to an instance of an object.  Web parts maintenance page: if you have permission, you can use this page to temporarily close web parts or remove personal settings. For more information, contact you site administrator. ==========================================================================================================

Problem with Subreports in Tablix in 2008 SQL Reporting Services

  
Hi,  I have set up a report to get data from an SQL Table to build a matrix of possible combinations of 2 products, works fine. For each combination a subreport should be called with row and colum value as parameter - also OK. But for most of the first and second column are the same column values handed to the subreport, for all other columns it works Deleting and recreating the matrix does not help   Thanks in advance

Problem while configuring SharePoint Usage Reporting

  
Hello all.    I was given an already developed MOSS 2007 (Standard) web application, up and running, and I was requested to activate the usage reporting services. So, I did a little search and found the following article that explains just how to do what I want:  http://technet.microsoft.com/en-us/library/cc262541(office.12).aspx As I go through the article, I come across this step on the "Enable usage reporting" section:  "On the SSP home page, in the Office SharePoint Usage Reporting section, click Usage reporting." So, now I notice that I don't have a Shared Service Provider and I can't go on with the aforementioned article. Alright, I did a little search and found this article:  http://technet.microsoft.com/en-us/library/cc262649(office.12).aspx Which would guide me through creating a SSP. No problemo. I follow the steps until I reach the 19th: "In the Index Server section, in Index Server, click the server on which you configured the Search service". And yet no option is available for me, and rather displays a "there's no index server" messsage. But hold on, the same article reads: "If there is no index server listed in the Index Server section, then no server in your farm has been assigned the index server role. To assign the index server role to a server in

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

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