Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
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 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)
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:
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:
Anyone else able to replicate this issue? still no resolution found.
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.
I would create a support case for this. I believe it is currently under investigation with our dev team for CRM 2013
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.
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?
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
We are facing similar kind of issue. Anybody found the resolution ?
Business Applications communities