Locale Datetime format in Crystal reports - ASP.net

[Former Member]

We have a crystal report called by ASP.net. In the report there is a Datetime field. The Datetime field's format has already been set as "system default short time" and the OS's locale has already been set as UK format. But the report is still showing US format. How can we fix this?

We are using CrystalReports10_NET_EmbeddedReporting.msm (merge modules) to launch crystal reports from the ASP.NET pages.

One of the website suggested to add a culture information (en-GB) in the web.config file.. but that did not solve the issue...

[former_member183750 · Accepted solution]

You're using an older, out of support version of CR. And I don't remember what type of support CR 10 had for localization in .NET.

Couple of things though:

1) Make sure you are using the latest updates for CR 10. You can look these up in the [downloads|http://service.sap.com/sap/bc/bsp/spn/bobj_download/main.htm] section.

2) Use the latest runtime - also available at the above link

3) Make sure you are using VS .NET that is supported with CR 10. See [this|https://wiki.sdn.sap.com/wiki/display/BOBJ/WhichCrystalReportsassemblyversionsaresupportedinwhichversionsofVisualStudio+.NET] wiki.

4) Check the CR 10 developer help files re. how CR 10 worked with localization

5) Upgrade to CR 2008 (12.x). You can try out CR 2008 for 30 days. The download is here;

http://www.sap.com/solutions/sapbusinessobjects/sme/freetrials/index.epx

I am not sure that hte modifications Bhushan suggested are for CR 10 - I don't think so...

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Edited by: Ludek Uher on Jul 29, 2010 2:19 PM

[former_member188030]

Hello,

set the culture info of the document (from property window) ie aspx to en-Gb

then couple of line in web.config...

<configSections>
  <sectionGroup name="businessObjects">
    <sectionGroup name="crystalReports">
      <section name="crystalReportViewer"
        type="System.Configuration.NameValueSectionHandler" />
    </sectionGroup>
  </sectionGroup>
</configSections>

<businessObjects>
  <crystalReports=>
    <crystalReportViewer>
      <add key="UseBrowserLocale" value="false"/>
    </crystalReportViewer>
  </crystalReports>
</businessObjects>

Hope it helps,

Thanks,

Bhushan.

[Former Member]

Hi Bhushan,

Thanks a lot.

We copied the "configsections" and "businessobjects" tags from your reply to our web.config (inside the configuration section, on top) and then change the page property like this:

<%@ Page Language="VB" Culture="en-GB" ClientTarget="upLevel" ValidateRequest="false" AutoEventWireup="false" CodeFile="AgentLoginLogout.aspx.vb" Inherits="SVAgentLoginLogout" %>

We also have a globalization truned on in Web.config.... Do we need this also?

<globalization requestEncoding="utf-8" responseEncoding="utf-8" culture="en-GB"/>

but it doesn't work, it still shows the dateformat as US (mm/dd/yyyy) ....any other suggestion?

Thanks,

Siva