Click here to Skip to main content
13,042,421 members (138,344 online)
Rate this:
Please Sign up or sign in to vote.
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) = "",
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">

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 21:18pm

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 6 Feb 2013
Copyright © CodeProject, 1999-2017
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