error when trying to add datetime parameter

[Gregory Kohle]

Hi,

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.
Thanks.

Regards,
Patrick

[Gregory Kohle]

Hi,

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.

Regards,
Patrick

[Vinoth Srinivasan]

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. 

 

Regards, 

Vinoth S.