SAP Knowledge Base Article - Public

1736244 - Alignment of numeric field is inconsistent

Symptom

  • Numeric field alignment in Group Footer appears inconsistent
  • The field shows some white space towards the end when it is set to right alignment

Environment

  • Crystal Report 2008
  • Crystal Report 2011

Reproducing the Issue

  1. Create a Crystal Report, insert group in it. example: Country name 
  2. Place Last Year Sales field on the Detail section
  3. Insert summary on  Last Year Sales and add to Group level
  4. Right click on the summary in Group Footer >>  Format Field >> Number Tab >> Customize >> Select Negatives from drop down list >> OK
  5. Now refresh the report

 Note: The Alignment of the summary value in Group footer will appear inconsistent as compared to the value in detail section

Cause

The reason behind the inconsistent alignment is that the field is set to display negative values. Crystal Report reserves some space to the right to show Negative signs.

Resolution

Right click on the summary in Group Footer >>  Format Field >> Number Tab >> Customize >> Select NONE for Negatives from drop down list >> OK

Keywords

Number alignment, summary , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports XI R2