Symptom
- Report field is smaller than data to be displayed.
- Field data overlaps or extends into the adjacent field.
- View Crystal Report in the ActiveX, DHTML, or .NET Web form viewer control.
Reproducing the Issue
- Crystal Reports 2008 SP2
- Crystal Reports XI R2
- Crystal Reports XI R1
- Visual Studio .NET 2003, 2005, or 2008
Cause
Resolution
To work around this behavior, in the Crystal Reports Designer, either apply the suggested formatting options to the field or replace the field with a formula.
Formatting Options
To view all the data in the field, complete these steps:
- Right-click the field.
- Click 'Format Text'.
- Select the 'Can Grow' check box.
To view only the first line of data, complete these steps:
- Right-click the field.
- Click 'Format Text'.
- Select the 'Can Grow' check box.
- Type "1" in the 'Maximum number of lines' box.
Replace a Field with a Formula
To view a specific number of characters in the field, complete these steps:
- Insert the database field into a formula using the 'Left' function.
- Specify the number of characters as a parameter of the function.
- Place the formula on the report.
- For example, the following formula field displays the first twelve characters of the Address1 field from the Customer table:
@AddressLeft({Customer.Address1}, 12)
Keywords
COVER UP OVER LAP TRUNCATE WEB DISPLAYING VIEWING SHOWING SPILLS OVER ON TOP Crystal Reports WEB Applications Field Formatting extend beyond overlay overlie overrun protrude project .net dotnet net webform application aspx c2017928 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem