Marty Zigman

Conversations with Marty Zigman

Certified Administrator • ERP • SuiteCloud

Date Parameter Error with SQL Reporting Services integrated with SharePoint

General

Tags:

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 LinkedIn

Marty Zigman

Holding three official certifications, Marty is widely recognized as a top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. A former Deloitte & Touche CPA and technology executive with CTO roles, he brings over 35 years of leadership in ERP, CRM, and eCommerce business systems. Contact Marty to engage directly.

BiographyYouTubeLinkedInX (Twitter)

One thought on “Date Parameter Error with SQL Reporting Services integrated with SharePoint

  1. I am also facing similar problem… all the report items which have date involved in it give error.
    Cant figure out why

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *