Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: XML
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:

=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 5-Feb-13 22:18pm

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

  Print Answers RSS
0 OriginalGriff 277
1 Maciej Los 210
2 BillWoodruff 195
3 DamithSL 195
4 Richard MacCutchan 178
0 OriginalGriff 5,130
1 DamithSL 4,197
2 Maciej Los 3,670
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,821


Advertise | Privacy | Mobile
Web01 | 2.8.141216.1 | Last Updated 6 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100