I have been challenged with this one for some time now. For our Remote Reporting Services, we are leveraging SQL Server 2008 Reporting services with integration into Windows SharePoint Services 3.0. Everything is promising, although the installation was challenging (something for another post).

We discovered that we have a problem when we use a date parameter type in Business Intelligence Studio.

When you run a report that was working fine and deployed to SharePoint,  you will get the following error message.  This only happens if there are date parameter types in the report:

Object reference not set
to an instance of an object.   at
Microsoft.Reporting.WebForms.CalendarDropDownInputControl.get_GetClientDisplayValueFunctionCall()

   at Microsoft.Reporting.WebForms.BaseParameterInputControl.get_ValidateValueFunctionCall()
   at Microsoft.Reporting.WebForms.ParameterControlCollection.get_ClientValidation()
   at Microsoft.Reporting.WebForms.ParametersArea.get_PromptValidationScript()
   at Microsoft.Reporting.WebForms.ParametersArea.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.WebControls.WebParts.WebPart.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

I trust we will get through it and look for a subsequent post once we do.