Date filter using incorrect timezone

Hayden Harrison

Asked On November 14, 2019 07:47 PM UTC

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.

Reply | Reply with quote

Vinoth Srinivasan [Syncfusion]

Replied On November 15, 2019 11:24 AM UTC

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:

@Styles.Render(DeviceDetection.IsMobile ? "~/styles/file-render-report-mobile" : "~/styles/file-render-report")

@Scripts.Render(DeviceDetection.IsMobile ? "~/scripts/report-render-mobile" : "~/scripts/report-render")

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.

Reply | Reply with quote

Hayden Harrison

Replied On November 17, 2019 08:40 PM UTC

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.

Reply | Reply with quote

Mahendran Shanmugam [Syncfusion]

Replied On November 18, 2019 09:53 AM UTC

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.

Reply | Reply with quote

Thread ID:	Created:	Updated:	Platform:	Replies:
149113	Nov 14,2019 07:47 PM UTC	Nov 18,2019 09:53 AM UTC	Report Platform	3

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US