Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Custom report date format issue after deploying to CRM RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    HI All,

    I have created multiple reports in visual studio using fetchxml and stored procedures with custom date parameters (date picker), when i deploy these reports in CRM, the date format is mm/dd/yyyy which is not correct. The date format settings in the CRM are dd/mm/yyyy both at the server and at user level. Request you to help on this asap

    Thank you,

    Naresh.

    Thursday, January 30, 2014 9:07 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    You need to either use textbox property to customize date field on report rdl or update SQL Query to get output in format you want.

    Here is a link for second approach : http://www.sql-server-helper.com/tips/date-formats.aspx

    Use format which you prefer to use.

    THanks

    ------------------

    If my answer helped you, kindly mark it as an answer. That might help someone else in future too

    Thursday, January 30, 2014 9:43 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    HI,

    When I preview the report in Visual Studio i can see the date parameter format as required i.e; dd/mm/yyyy, but after i deploy the report to CRM the date parameter format is changed to mm/dd/yyyy even if all the settings related to date are in required format everywhere. Pls help.

    Thanks...

    Thursday, January 30, 2014 9:47 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Okay. Do following 2 steps :

    1. Go to CRM and go to system settings. Check the date format there, It is under Formats

    2. Then check your own personal Format options under, File --> Options.

    See if the formats are fine. I think thats where you are getting different format for dates. It is by default set to US settings

    Thursday, January 30, 2014 9:51 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    HI,

    Both the settings that you mentioned are good but still am facing the problem.

    Thank you...

    Thursday, January 30, 2014 10:01 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi 

    Check the below links..

    http://social.microsoft.com/Forums/en-US/7277b11b-226c-4b57-a8bc-664fc499ff6d/urgent-how-to-change-date-format-in-date-picker-for-ssrs-fetchxml-reports-for-mscrm-2011?forum=crmdevelopment

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/32b62d3c-9a32-41bd-b7ad-95c3b89a7668/ssrs-datetime-parameter-value-should-display-in-ddmmyyyy-format?forum=sqlreportingservices

    Hope this helps..



    • Edited by Suresh Sorde Thursday, January 30, 2014 10:21 AM
    Thursday, January 30, 2014 10:18 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    If you want a specific format for a date field in a report, set the Format property of the text box in the Report Designer to that format (e.g. dd/MM/yyyy). This will override the language settings

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Thursday, January 30, 2014 11:03 AM
    Moderator