Date Parameter Error with SQL Reporting Services integrated with SharePoint

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.

Marty Zigman

Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - YouTube