SAP Knowledge Base Article - Public

1218877 - Fields overlap adjacent fields when viewing Crystal Report in ActiveX, DHTML, or .NET Web Form Viewer

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

This issue has been identified and logged under problem report ID ADAPT00093078.

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:

  1. Right-click the field.
  2. Click 'Format Text'.
  3. Select the 'Can Grow' check box.

To view only the first line of data, complete these steps:

  1. Right-click the field.
  2. Click 'Format Text'.
  3. Select the 'Can Grow' check box.
  4. 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:

  1. Insert the database field into a formula using the 'Left' function.
  2. Specify the number of characters as a parameter of the function.
  3. Place the formula on the report.
  4. For example, the following formula field displays the first twelve characters of the Address1 field from the Customer table:
@Address
Left({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

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2