Answered by:
CRM

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
-
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 -
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
- Proposed as answer by Azevedo PedroMVP Monday, February 4, 2013 12:22 PM
- Marked as answer by HamedFarvahar Thursday, February 7, 2013 9:05 AM
Monday, February 4, 2013 12:22 PM
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.
- Merged by Andrii ButenkoMVP, Moderator Monday, February 4, 2013 11:16 AM
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.
- Changed type Andrii ButenkoMVP, Moderator Monday, February 4, 2013 11:14 AM
- Merged by Andrii ButenkoMVP, Moderator Monday, February 4, 2013 11:15 AM
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
- Proposed as answer by Azevedo PedroMVP Monday, February 4, 2013 11:12 AM
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
- Proposed as answer by Azevedo PedroMVP Monday, February 4, 2013 12:22 PM
- Marked as answer by HamedFarvahar Thursday, February 7, 2013 9:05 AM
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