1. Home
  2. Forum
  3. Report Platform
  4. Format of date parameter incorrect
If you became a customer of the Syncfusion� Reporting Platform or the Report Viewer, Report Designer, or Report Writer components before October 2019 and have questions related to those products, you can request support through our forum system. However, please note that this support system is only for existing customers who are still using the Syncfusion� Reporting Platform or its components and not for new customers looking for reporting products from Syncfusion�.

For new customers or those with general reporting questions, we recommend contacting our support team at https://support.boldreports.com/, which is a separate brand created by Syncfusion� for its reporting solutions. Our team will be happy to assist you with any questions you may have.

Thank you for choosing Syncfusion� for your reporting needs.

Format of date parameter incorrect

Hi, 

I have installed the report server on a server which is setup for en-GB. (English - United Kingdom) 
When I come to use the report viewer, my date parameter is in US format mm/dd/yy rather than the locale setup on the server (dd/mm/yy). 
My web browser is also set for en-GB. 

In the report server settings there is an option for date format which I have set to dd/mm/yy, however my reports still show the date parameter in US format. 

I did come accross this post, https://www.syncfusion.com/forums/132567/problems-with-datetime-report-parameter which outlined some manual file modification, the sections detailed (locale property) don't exist in the version of the file I have. (latest as of today)

How can I configure report server to utilise dd/mm/yy in report. All my date data is in dd/mm/yy so passing anything parameter wise isn't possible currently. 

Damian


1 Reply
YD Yuvaraj Devarajan Syncfusion Team June 5, 2018 01:14 PM UTC

Hi Damian, 

Thanks for contacting Syncfusion support. 

Our ReportViewer DateTime parameter is rendered based on ReportViewer control culture format and it does not depend on the system regional settings. If we have to change the date format of the parameter, then we need to modify the ReportViewer locale property to required culture. Hence we have  provided the workaround support to load the report parameter based on locale culture and its working properly at our end. The locale property name is doesn’t changed for the latest Report Server. Please follow the below steps to apply the fix in your Report Server Application.   
  
1.Ensure to stop the Report Server application from the desktop shortcut – “Stop Syncfusion Report Server”.   
  
2.Download your required culture script from the below link.   
  
3. Paste the downloaded culture script and past into the below location.   
    {{InatalledLocation}}:\Program Files (x86)\Syncfusion\Report Server\ReportServer.Web\ Scripts\EssentialJS\i18n   
 
4. Refer the pasted file in the “i18n” folder to “ReportViewer.cshtml” file like below from the below location.   
    {{InatalledLocation}}:\Program Files (x86)\Syncfusion\Report Server\ReportServer.Web\Views\FileRender   
  
   
  
5. Now set the locale property in ReportViewer control render page that is “ReportViewer.cshtml” page like below,   
  
     
  
6. Start the Report Server Application from the desktop shortcut – “Start Syncfusion Report Server”.   

Regards, 
Yuvaraj D. 


Loader.
Up arrow icon