Date filter using incorrect timezone

[Hayden Harrison]

I'm using the report viewer embedded via an Iframe.  My report has a date filter which has the default value expression of "Today()" however this is returning yesterdays date (I suspect UTC date) however my timezone is New Zealand (UTC + 13).  I can see in the network request that this date has already been calculated when I request the report from the server.  I've set my timezone to New Zealand inside the syncfusion settings and I've tried setting the report language to en-NZ however neither has worked.

Is there somewhere I can tell syncfusion reports which timezone to use for my filters?

Cheers.

[Vinoth Srinivasan]

Hi Hayden, 

We need to follow the below steps to render the date based on your culture in your Application. We have provided en-AU culture as example. 

  

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. 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/en-AU1981788910 

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-AU 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-AU folder with messages.po file. 

http://www.syncfusion.com/downloads/support/directtrac/general/ze/en-AU-814081444 

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 Australia as shown in below snap. 

 

Output snap: 

 

Please let us know if you need any clarification. 

Regards, 

Vinoth S. 

[Hayden Harrison]

I've previously done the first half of these steps to get my date to format in the correct order for NZ (dd/mm/yyyy) which works fine but my issue now is the actual timezone seems to be wrong. i.e. the control shows yesterdays date as New Zealand is UTC + 12. I've set my timezone to NZ in the report server settings to no avail.  Can you confirm these steps below will make the report date picker use the correct timezone?  I don't see anything in these files that specifies the timezone to use.    

[Mahendran Shanmugam]

Hi Hayden, 

We suspect you are getting timezone issue when choosing the datatime value from parameter block. So you can follow the previously shared steps and instead of en-AU could you please use the en-NZ. Please find the below attached files for your reference. 

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

Let us know if you need any clarification. 

Regards, 

Mahendran S.