I make report with BIDS in visual studio 2008 and it is very good working in CRM report.but I find problem with date.
I have persian language in CRM and when I run my report in BIDS it is working very good but and my date in report is persian But when I publish it in CRM a date is change in English and with a wrong shape for example:30/1/2013 to 1/30/2012 and it is exactly wrong so I use this way with this issue and Error:
first I use this way and put in value of my field that it is new_datefund a value is:
and when I run it in BIDS it have #Error
someone told me use this:
=IIf (CStr(Fields!datefield) Is Nothing Or CStr(Fields!datefield) = "",
but It is not true smoothly.
Second way I use this code:
=CDate(Microsoft.Crm.Reporting.RdlHelper.DateTimeUtility.ConvertUtcToLocalTime(DateTime.UtcNow, Parameters!CRM_UserTimeZoneName.Value)).ToString("g", Microsoft.Crm.Reporting.RdlHelper.ReportCultureInfo.GetCultureInfo(Parameters))
but it is not recognize ConvertUtcToLocalTime and say to me Unrecognize identifier
third way I save my Rdl file and then I see code it with Notpat And add to paramtere this:
but when I publish it in CRM it have Error
and when I add this paramter in BIDS in my Dataset..when I run report it want to me to fill te new_date fund with date but it haven't any influance to run my report.
please help me I try to many wat but I havn't any result
and I really hank.....