DateTime datatype in ReportParameter

[Albert K]

Hi ,

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.

 

[Mahendran Shanmugam]

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. 

[Albert K]

Please find enclosed my example RDL

Attachment: emr_e1fc4a39.zip

[Albert K]

Hi,  

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.

[Vinoth Srinivasan]

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/[e-mail](language,".js")"></script> 

              <script src="~/Scripts/EssentialJS/i18n/[e-mail](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. 

[Albert K]

Thank you for the update and it worked for the Report Viewer but the designer still does not work when the date is greater then 12, for example 14/Aug/2019.   Also the display in the designer field is also in US format. 

[Vinoth Srinivasan]

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.