DateTime datatype in ReportParameter

I have this problem where the DateTime parameter is linked to the filter of a tablix.  In the Preview mode after Selecting the Parameter a few times the error will occur as shown below.

 

Hi Albert, 

 

We have checked the mentioned parameter issue with our Report Designer but it is working properly at our end. So could you please share your issue reproducible RDL file to validate the mentioned problem at our end. 

 

Regards, 

Mahendran S. 

Is there any progress on the issue.  I think I might have got to the thing that is causing the issue.  My system dateTime format is set to GB ie dd-mm-yyyy.  The parameter  for datetime will always show the US date format so everytime you select something like 01/24/2018  the error will appear, meaning any day that is greater then 12 will cause error.  

Is there a fix ? Thank you.

Hi Albert, 

 

We have provided the workaround support to load the report parameter based on locale culture. 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. 

https://www.syncfusion.com/downloads/support/directtrac/general/ze/scripts1954100.zip 

 

3.Paste the downloaded culture script file only into the below locations as shown in below snap. 

{{InatalledLocation}}:\Program Files (x86)\Syncfusion\Report Server\ReportServer.Web\ Scripts\EssentialJS\i18n\ 

{{InatalledLocation}}:\Syncfusion\Report Server\ReportServer.Web\  Scripts\EssentialJS\i18n\ 

 

 

4.Paste the downloaded localetext script file only into the below locations as shown in below snap. 

 {{InatalledLocation}}:\Program Files (x86)\Syncfusion\Report Server\ReportServer.Web\ Scripts\Localization\reportviewer 

{{InatalledLocation}}:\Syncfusion\Report Server\ReportServer.Web\ Scripts\Localization\reportviewer 

 

 

5. Refer the pasted file reference in to “ReportViewer.cshtml” file like below from the below locations as shown in below code example and snap.   

    {{InatalledLocation}}:\Program Files (x86)\Syncfusion\Report Server\ReportServer.Web\Views\FileRender   

    {{InatalledLocation}}:\Syncfusion\Report Server\ReportServer.Web\Views\FileRender   

 

ReportViewer.cshtml: 

<meta http-equiv="X-UA-Compatible" content="IE=edge" />      <meta name="viewport" content="width=device-width" />        <link rel='nofollow' href="@Url.Content("~/Content/Styles/EssentialJS/reportviewer/bootstrap-theme/ej.reportviewer.min.css")" rel="stylesheet" type="text/css" />            @Styles.Render(DeviceDetection.IsMobile ? "~/styles/file-render-report-mobile" : "~/styles/file-render-report")      @Scripts.Render(DeviceDetection.IsMobile ? "~/scripts/report-render-mobile" : "~/scripts/report-render")        <script src="~/Scripts/Localization/ReportViewer/ej.localetexts.@string.Concat(language,".js")"></script>                <script src="~/Scripts/EssentialJS/i18n/ej.culture.@string.Concat(language,".min.js")"></script>      <script>          var filterParameters = JSON.parse('@Html.Raw(ViewBag.FilterParameters)');          var itemViewShareIframeUrl = "@Url.Action("shareItemView", "items")";          var getViewParameterUrl = "@Url.Action("GetReportViewParameter", "ReportViews")";          var addViewUrl = "@Url.Action("onfiltersave", "ReportViews")";          var deleteViewUrl = "@Url.Action("DeleteView", "ReportViews")";          var updateViewUrl = "@Url.Action("UpdateView", "ReportViews")";          var getSavedViewUrl = "@Url.Action("GetViews", "ReportViews")";          var filterQueryUrl = "@Url.Action("GetFilterQuery", "FileRender")";          var itemViewShareIframeUrl = "@Url.Action("shareItemView", "items")";          var publicReportAuthentication = "@HttpContext.Current.Request.IsAuthenticated";          var getLinkReportName = "@ViewBag.ItemName";      </script>

 

 

 

 

6. create the en-GB folder add messages.po file to load the server with culture in below server installed locations as shown in below snap. 

{{InatalledLocation}}:\Program Files (x86)\Syncfusion\Report Server\ReportServer.Web\ locale 

{{InatalledLocation}}:\Syncfusion\Report Server\ReportServer.Web\locale 

 

 

Please find the below en-GB folder with messages.po file. 

https://www.syncfusion.com/downloads/support/directtrac/general/ze/en-GB693606437.zip 

 

7. Start the Report Server Application from the desktop shortcut – “Start Syncfusion Report Server”.   

 

8. Click the culture button in server and change the culture to United Kingdom as shown in below snap. 

 

Output snap: 

 

 

Please let us know if you need any clarification. 

 

Regards, 

Vinoth S. 

Hi Albert, 

We were able to reproduce the mentioned culture issue in our Report Designer. We will fix this issue and it will be reflected in our upcoming Report Platform release which is estimated to be rolled out on first week of the September 2019. 

Regards, 

Vinoth S.