Click here to Skip to main content
14,880,624 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.....
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900