I make report with BIDS in visual studio 2008 and it is very good working

Hi All!!!

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:
=CDate(Fields!FirstDayOfThisMonth.Value).ToString("MMM-yy", System.Globalization.CultureInfo.CreateSpecificCulture("CultureName"))
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) = "",
Nothing,
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:
<queryparameter name="new_datefund">
<value>=Format(Parameters!new_datefund.Value,"MM-dd-yyyy")

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.....

Tags: XML