locked
CRM RRS feed

  • Question

  • Hi i make a report with fetch xml in BIDS from visual studio 2008 so it is working very good but i have this problem!!!!!

    when I preview it in  BIDS,I have a true Date(one of my field is Date and I have persian language in CRM too) with Persian language and I want exactly this.

    But when I add this to Report in CRM my date come in English and I haven't it.

    what can I do to solve this problem to have persian date in Microsoft CRM.

    Monday, February 4, 2013 10:46 AM

Answers

All replies

  • Hi i make a report with fetch xml in BIDS from visual studio 2008 so it is working very good but i have this problem!!!!!

    when I preview it in  BIDS,I have a true Date(one of my field is Date and I have persian language in CRM too) with Persian language and I want exactly this.

    But when I add this to Report in CRM my date come in English and I haven't it.

    what can I do to solve this problem to have persian date in Microsoft CRM.

    Monday, February 4, 2013 10:43 AM
  • Hi i make a report with fetch xml in BIDS from visual studio 2008 so it is working very good but i have this problem!!!!!

    when I preview it in  BIDS,I have a true Date(one of my field is Date and I have persian language in CRM too) with Persian language and I want exactly this.

    But when I add this to Report in CRM my date come in English and I haven't it.

    what can I do to solve this problem to have persian date in Microsoft CRM.

    Monday, February 4, 2013 10:46 AM
  • Hi,

    See this great article: http://community.dynamics.com/product/crm/crmtechnical/b/crmteamblog/archive/2011/12/20/personalizing-reports-for-microsoft-dynamics-crm-online.aspx

    Great tips to personalize reports.

    Hope this helps.
    If i answered your question, please mark the response as an answer and also vote as helpful.


    Pedro Azevedo Crm Specialist 4.0\2011

    Monday, February 4, 2013 11:12 AM
  • My problem Don't solve!!!!!!

    Do you have another Idea.....

    I want my date in CRM after I create Report with fetchxml have persian date....

    Monday, February 4, 2013 12:00 PM
  • Hi,

    Did you try this:

    CDate(Fields!FirstDayOfThisMonth.Value).ToString("MMM-yy", System.Globalization.CultureInfo.CreateSpecificCulture("CultureName"))

    See more information here: http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo.createspecificculture.aspx

    Or Try this:

    CDate(Microsoft.Crm.Reporting.RdlHelper.DateTimeUtility.ConvertUtcToLocalTime(DateTime.UtcNow, Parameters!CRM_UserTimeZoneName.Value)).ToString("g", Microsoft.Crm.Reporting.RdlHelper.ReportCultureInfo.GetCultureInfo(Parameters))

    Source: http://blog.mscrm-consulting.de/?p=16

    Hope this helps.
    If i answered your question, please mark the response as an answer and also vote as helpful.


    Pedro Azevedo Crm Specialist 4.0\2011

    Monday, February 4, 2013 12:22 PM
  • Yes I use it But have problem and error this #error for first way of you

    and for second it is unknown  ConvertUtcLocalTime

    
    
    
    Monday, February 4, 2013 12:48 PM
  • I use deplete FirstDayOfThisMonth my field and my field is new_DateFund and it's type is Date But have #error

    please help me I think you can help to me

    
    Monday, February 4, 2013 12:53 PM
  • Hi,

    It is strange not recognize ConvertUtcLocalTime, try do this: http://nishantrana.wordpress.com/2012/01/10/error-convertutctolocaltime-is-not-a-member-of-microsoft-crm-reporting-rdlhelper-datetimeutility-while-creating-report-using-report-wizard-crm-2011/

    It is giving #error, this field is always filled if is not please make this code:

    =IIf (CStr(Fields!datefield) Is Nothing Or CStr(Fields!datefield) = "",
    	Nothing,
    	Fields!datefield)

    Hope this help


    Pedro Azevedo Crm Specialist 4.0\2011

    • Marked as answer by HamedFarvahar Thursday, February 7, 2013 9:05 AM
    Monday, February 4, 2013 2:31 PM
  • Realy I am very new in fetchxml AND BIDS any body can Help to me How can I use this?

    Of course it is better  with image .

    Tuesday, February 5, 2013 6:37 AM
  • Hi, 

    Many people are facing the same issue. Please look this Discussion this might be helpful - https://community.dynamics.com/crm/f/117/t/136919 

    Thursday, October 20, 2016 7:18 AM