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
- Create a Crystal Report, insert group in it. example: Country name
- Place Last Year Sales field on the Detail section
- Insert summary on Last Year Sales and add to Group level
- Right click on the summary in Group Footer >> Format Field >> Number Tab >> Customize >> Select Negatives from drop down list >> OK
- 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