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

DateTime report parameter

Thread ID:





130596 May 19,2017 02:19 PM UTC May 22,2017 10:32 AM UTC Report Platform 1
Tags: Report Viewer
Caner Mollaoglu
Asked On May 19, 2017 02:19 PM UTC

Hello again,
First of all thanx for all your helps. I'm gonna ask a question.
I have a RDL report. I'm using some kind of parameters all works fine but the datetime parameter doesn't. I sent you a print screen which summarize my trouble and also I write it down here:
There is a datetime parameter as I said, I choose it and the rdl report works a stored procedure with using this datetime parameter. But I think that the format of the datetime parameter is not proper to use my sql query.
Could you please help me?
Thank you.

Attachment: rdlreportdateproblem_8e1faba2.rar

Yuvaraj Devarajan [Syncfusion]
Replied On May 22, 2017 10:32 AM UTC

Hi Caner, 

Yes, the mentioned problem happens due to different date format used for query filter. Our parameter dropdown component will render based on machine culture, hence the parameter date format is different from SQL date format. To overcome this problem, we request you to convert the date value of the parameter in query text using “Convert()” function as shown in below screenshot. 


Please find the below MSDN documentation for more detail, 

Yuvaraj D. 


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

This page will automatically be redirected to the 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