.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

reports published to SharePoint not refreshing in "sharepoint 2007"

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :SharePoint

Hello All,

My Issue: SSRS reports published to SharePoint not refreshing in “sharepoint 2007”.

The reports have the ‘Auto refresh’ property set to 15 sec. When the reports are viewed in the report manager the reports refresh and update with the new data entered in the Transactional system.

I now want to publish these reports to SharePoint in a dashboard format.

My first attempt to do this was with Performance point server. I added the report to the Performance point dashboard designer and then created a dashboard with these reports. I then published the rep

View Complete Post

More Related Resource Links

Building SSRS reports based on SharePoint 2007 lists

Hi,   I'm building a SSRS report, and I want to get data out of a SharePoint 2007 list. The difficulty I'm facing is the following: The SharePoint server is behind an ISA Server, and is configured for Form-Based Authentication. Is there a way to keep the FBA and retreve information out of a SharePoint list with reporting services?   Kind Regards,  AVermaas    

Win server 2003+ Sharepoint 2007+SQL Server 2008 ,reports view issue?


I hope someone may shed some light on a serious obstacle encountered on a client site:

We have implemented a SharePoint integrated report services solution for the client on a single server

Server = Windows 2003

SQL = 2008

MOSS 2007

Web application = servername:8888 (default) - windows auth

Web application extension 1 servername:8889 (extranet) forms auth

Web application extension 2 servername:8887 (intranet) forms auth

Reports are visible and can be run (renders) on internal sites

However, there is an external site which allows users to access the reports - the issue is, the reports then dont run and I get this:

"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode."

Though I have not actually seen the firewall config of the AAM, the client assures me it has been setup properly.

If the AAM is setup correctly, what could be the problem? The server is clearly available and confgured in SharePoint integrated mode.


has anyone experienced the scenario where clients want to publish their reports on an external site? What can one do to see any errors other than the one line message (tried enabling custom errors, but no good)

SSRS Reports Not updating in Sharepoint 2007


Hello All,

I created some reports in SSRS 2008, The reports data source is a live transactional data source. The reports are to auto refresh every minute displaying any new info that  was put on to the system in the last minute. The auto refresh property on each report is set to 60 sec. to trigger the refreshing of the reports.

The problem: when i run the reports in the report manager the every thing works fine, the report runs, refreshes, and the figures are updated.

I am now displaying these reports in Sharepoint 2007 via the "report viewer" facilitated by the RSWebPart that i installed on the Sharepoint instance. 

The reports are displayed fine in the viewer, but my problem is that it does not auto refresh with the updated info.


I figure it is a caching issue but how to get around? HELP!

Write Custom WebParts for SharePoint 2007

The popularity of SharePoint Portal Server 2003 led Microsoft to tightly integrate the next SharePoint version, Microsoft Office SharePoint Server (MOSS) 2007, with its ASP.NET 2.0 WebPart framework. This tight integration enables the ASP.NET and SharePoint developer to do a number of things that previously weren't possible

SharePoint 2007 Workflows - Things to Consider Before You Start

SharePoint 2007 (MOSS) utilizes the Workflow Foundation (WF) to enable workflows on lists and content types. But before you start doing cartwheels there are few things you should know before you get started. The experiences I'll be discussing are not from book smarts but from building real MOSS solutions that are in production today.

Writing Custom Web Parts for SharePoint 2007

As I mentioned in an earlier blog post, SharePoint 2007 is built on top of ASP.NET 2.0, which means you can now use ASP.NET 2.0 features (Forms Authentication, Master Pages, Membership, Site Navigation, New Data Controls, etc) when building SharePoint sites. This is true for both the new Windows SharePoint Services 3.0 version (which will be a free download) as well as Microsoft Office SharePoint Server 2007 (which costs money).

Viewing Reports with SharePoint 2.0 Web Parts

Reporting Services provides several Web Parts that work with specific versions of a report server and in particular deployment modes. If you want to access report server content on a SharePoint site from a native mode report server, use the SharePoint 2.0 Web Parts that are included with Reporting Services. Instructions for installing and using the 2.0 Web Parts are provided in this topic.

Office Space: Custom Field Types for SharePoint 2007


Custom field types provide a powerful way to define a reusable SharePoint column definitions.

Ted Pattison

MSDN Magazine May 2009

Office Space: Security Programming in SharePoint 2007


This month Ted Pattison presents an overview of programming security and permissions for Windows SharePoint Services 3.0.

Ted Pattison

MSDN Magazine February 2008

Office Space: Events in SharePoint 2007


Windows SharePoint Services (WSS) 3.0 provides a new and improved infrastructure for handling server-side events. In this installment of Office Space, we look at techniques for hooking up Before Events and After Events using both Features and code.

Ted Pattison

MSDN Magazine November 2007

Office Space: Solution Deployment with SharePoint 2007


WSS 3.0 introduces a new deployment mechanism that lets you move your development efforts into a staging or production environment.

Ted Pattison

MSDN Magazine August 2007

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

How to add custom list entries to mysite's calendar in Sharepoint 2007 site?


I would like to know below things

(1) How to create MySite for one specific member with other or administrator's access?

(2) Scenario : Administrator have created one SP2007 site. now Administrator have created one calendar (Sample calendar). Administrator have added some entries in calendar. now one user entered in portal site ansd view the calendar and he click on MySite menu. so this sample calendar entries should enter in that user's mysite calendar. How this can be achieved?

Thanks in advance.
Regards, Praful Udade

Profile Pictures not displayed in Discussion Board in SharePoint 2007

Picture Placeholders are displayed instead of Profile Images in Discussion boards in MOSS 2007 but when you click on the user, their pictures appeared in MySites, also with Search People. How to fix this?!

How to enable Mixed authentication for single webapplication in sharepoint 2007?


Hi All,

      I have requiremnt to enable Mixed mode ( Windows & Forms Based) authentication on Single web application( with out extending). I have done it in Sharepoint server 2010, It is so simple also. But my requirement is on Moss 2007. I have found some Post and gone through Those posts, in those posts, all are suggesting to extend the default webapllication and enabling forms authentication on extending/Default application another one is on Wondows authentication.

  Is it way to suggest the client or any other alternative to enable the mixed mode authentication?

please suggest me with right solution. Thank you in advance.

Thanks & regards,

Naresh Kapa.


Best Practices for developing accessible web sites in SharePoint 2007


I'm currently busy with an overview of Best Practices for developing accessible web sites in SharePoint 2007. After a little research I have noticed that the challenges I have faced so far are mostly XHTML/CSS/JS related and there are actually very few SharePoint 2007 specific issues: this has to do with the fact that we use very little to none of standard SharePoint controls in the Internet facing web sites we deliver.


As I would like to share the Best Practices I'm writing with the community I've been wondering whether you have tried to develop an accessible web site in SharePoint 2007 yourself and faced any challenges you would like to share. To make myself clear I'm looking for issues and challenges and not solutions in particular (these are welcome as well by the way).

SharePoint 2007 WCM Solutions can be accessible


Recently I've been busy with a research on accessibility of Web Content Management solutions based on SharePoint 2007. My outcome is: SharePoint 2007 WCM solutions can be accessible and depending on the approach you can score up to 95% WCAG 1.0 Priority 2.0 compliancy without any toolkit.

I've been wondering whether anybody else shares my opinion or has his/her own...

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