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

  • Question

  • 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

  • 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
  • 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
  • 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
  • HI,

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

    Thank you...

    Thursday, January 30, 2014 10:01 AM
  • 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
  • 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