SAP Knowledge Base Article - Public

1894959 - .NET crystal report web application doesn't display leading zero

Symptom

.NET crystal report web application doesn't show leading zero of crystal report

Environment

  • Visual studio 2008
  • Windows 2008 server

Reproducing the Issue

  1. Build a simple .NET crystal report web application to display a crystal report using crystalReportViewer control
  2. Deploy the web application to Internet Information Services (IIS)
  3. Visit the web application using internet explorer and check the leading zero of crystal report's data

Cause

  • Server OS is configured to not display leading zero
  • IIS Manager's application pools is not running under corresponding account

Resolution

  1. Login server OS using administrator's account
  2. Go to control panel at Server OS
  3. Go to Region and Language > click Additional settings > go to Numbers tab > check setting of Display leading zeros > change the setting to show leading zero
  4. Go to Internet Information Services(IIS) Manger > Basic Settings > check the name of Application pool
  5. Go to Internet Information Services(IIS) Manger > Application Pools > select the Application pool > Advanced Settings > Identity > change it from ApplicationPoolIdentity to customer account > input administrator's account information
  6. Restart server in Internet Information Services(IIS) Manger

Keywords

.net, crystal report viewer, leading zero, zero before decimal point, data format , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports, developer version for Microsoft Visual Studio ; SAP Crystal Reports, version for Visual Studio .NET 2008