We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

error when trying to add datetime parameter

Thread ID:





129799 Apr 4,2017 09:27 AM UTC Apr 5,2017 12:15 PM UTC Report Platform 2
Tags: Report Designer
Gregory Kohle
Asked On April 4, 2017 09:27 AM UTC


when I try to add a datetime parameter in the sql query an error occurs.
Here is the errormessage:

Is there some kind of fix for this? The format of the field is datetime and the parameter is also datetime.


Gregory Kohle
Replied On April 5, 2017 07:11 AM UTC


I try adding the parameter via the Filters tab.
There I get the following error message:

But I picked Date/Time as type for the parameter.


Vinoth Srinivasan [Syncfusion]
Replied On April 5, 2017 12:15 PM UTC

Hi Patrick, 
Thanks for contacting Syncfusion Support. 
We suspect that the error occurs due to the dataset field datatype mismatch with the query parameter. So, we request you to ensure both the dataset field and query parameters having same data type. If you still face any issue then we request you to share the report with dummy data to reproduce the issue at our end. It will be helpful for us to provide the solution at the earliest. 
Vinoth S. 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon