Report Date Parameter/Calendar control format not reflecting user options on refresh

(0) Share

Report

Posted on by Community Member

We are facing an issue at our client related to date parameters where after changing the date with the date picker it changes the date format. Everything works fine when the user’s personal options match the default US date format (MM/dd/yyyy) but the behaviour is not as expected when user options are set the Canadian format dd/MM/yyyy. Below are the steps for a very basic report – no custom logic on the parameter at all.

Select a date (August 2, 2014)

Date displays as “yyyy-MM-dd” instead of “dd/MM/yyyy”

Run report and now day and month are flipped

Selecting calendar control shows February.

There are many related posts out there related to the date picker in CRM reports but none of the resolutions seem to apply to us and no one else has described this behaviour. This worked fine in CRM 4.

Resolutions tried (we have been at this a while):

- Modifying regional settings on CRM server

- Modifying regional settings on SSRS server

- Modified user regional settings in control panel

- Modified browser language settings

- Changing global date format in CRM organization

- Changing the personal date format in CRM options

- Adding a Language element to the report .rdl

- Modifying the date format by javascript

- Modifying the report viewer control on the CRM and SSRS servers with language="en-CA"

- Applying latest cumulative update for SSRS (SQL Server 2012 SP1 CU3)

- Applying latest service pack for CRM (CRM 2013 SP1)

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Community Member on at

Like (0)

Report

RE: Report Date Parameter/Calendar control format not reflecting user options on refresh

We are facing similar kind of issue. Anybody found the resolution ?

Was this reply helpful? Yes No
ram r on at

Like (0)

Report

RE: Report Date Parameter/Calendar control format not reflecting user options on refresh

Disclaimer: Below is not a supported customization, take a backup before updating a file. This defaults to a single date time format.

I have faced similar issue in one of my old projects, finally adding the culture directly to the crm's reportviewer.aspx in application server worked for me. The same is highlighted in red(for my scenario it was Britain)

<%@ Page Language="C#" AutoEventWireup="true" Inherits="Microsoft.ReportingServices.WebServer.ReportViewerPage" Culture="en-GB"%>

Reference is as follows for ssrs server, But do not update reportviewer.aspx of ssrs server instead update crm's report viewer in application server

https://bhavikmerchant.wordpress.com/2011/02/05/incorrect-format-for-date-params-ssrs-integrated-mode-or-using-report-viewer-web-part/

Was this reply helpful? Yes No
Microsoft Dynamics 365 36 on at

Like (0)

Report

RE: Report Date Parameter/Calendar control format not reflecting user options on refresh

Hello All,

We are facing the similar kind of issue where we are building a ssrs report for Dynamics 365. We are retrieving data based on a date range. The report works fine when the user personal settings are US english. However we get report processing error when user setting are changed to UK or any other location.
In SSRS report we are converting the user input as well as the system date filed to a common MM/dd/yyyy string before comparison then to it does not work.

Please suggest what to do?

Was this reply helpful? Yes No
mscrmba on at

Like (0)

Report

RE: Report Date Parameter/Calendar control format not reflecting user options on refresh

What browser are you using? Have you tried any others?

I know we had some issues with IE11 compatibility at one stage that affected the date picker.

Think it's unlikely to be the solution but it might be worthwhile trying.

Was this reply helpful? Yes No
AaronRic 10,035 on at

Like (0)

Report

RE: Report Date Parameter/Calendar control format not reflecting user options on refresh

I would create a support case for this. I believe it is currently under investigation with our dev team for CRM 2013

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Report Date Parameter/Calendar control format not reflecting user options on refresh

Hello Ben,

I have faced the same issue recently.

Looks like because the report is being rendered inside of a Dynamics CRM Web Page, the date control is "inheriting" the format dates of the User settings and/or System Settings and changes the box.

The issue does not happens when accessing the report directly from the Reporting Services.

Matching the date format between Dynamics CRM and the client machine, works for me as well.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Report Date Parameter/Calendar control format not reflecting user options on refresh

Anyone else able to replicate this issue? still no resolution found.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Report Date Parameter/Calendar control format not reflecting user options on refresh

Hello Aileen,

I had not seen that link but unfortunately it does not resolve the issue.

1) it does not explain why report parameters work just fine when the user's CRM personal options are reset back to US default MM/dd/yyyy in CRM.

2) I have confirmed that the regional settings of both the machine used to deploy the report and the client browser used to view the report are set to English (Canada) language and display options:

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (0)

Report

RE: Report Date Parameter/Calendar control format not reflecting user options on refresh

Hi Ben,

As I know, this parameter format is not related to the CRM Setting and nor the personal setting of CRM user, it depends on the client machine.

Have you tried this link:

www.wiseowl.co.uk/.../ssrs-date-formats.htm

Thank you.

Was this reply helpful? Yes No