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.
Unfortunately, activation email could not send to your email. Please try again.

DateTime report parameter

Thread ID:

Created:

Updated:

Platform:

Replies:

130596 May 19,2017 10:19 AM May 22,2017 06:32 AM Report Platform 1
loading
Tags: Report Viewer
Caner Mollaoglu
Asked On May 19, 2017 10:19 AM

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 06:32 AM

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, 

Regards, 
Yuvaraj D. 


CONFIRMATION

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.

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.

;