SAP Knowledge Base Article - Public

1280441 - Cross-Tab text in the headers or rows are truncated in Crystal Reports

Symptom

  • Text cut off.
  • Cross-Tab column header truncated in Crystal Reports.
  • Can Grow option grayed out, for rows or columns in a cross-tab.
  • Can Grow option is disabled when formatting a cell of a cross-tab in Crystal Reports.
  • Cross-Tab column header does not resize automatically to fit the text in Crystal Reports.
           
      cross-tab - 01.png
       
        
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020 

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Insert a cross-tab on the report.
  3. Add at least one row, one column and one summry.
  4. When previewing the report, notice the column header text is truncated.
  5. When editing the cross-tab, notice the "Can Grow" option is grayed out.

Cause

  • Cross-Tab columns and row width are static in Crystal Reports, in order to keep the cross-tab columns and rows even.
       
  • This is why text that are longer than the cell width will be truncated, and it is also why the "Can Grow" option for a cross-tab cell is grayed out.

Resolution

  • If the row or column headers text are truncated, manually resize the width of the cross-tab row or column cell.
       
    1. In Crystal Reports, open the report.
       
    2. Preview the report.
         
    3. On the cross-tab, select the cell that contains the row or column header text, and over on the right edge of the cell until it displays a left and right arrow, then resize the cell to display the whole text.    
         
       cross-tab - 02.png 
           
        
    4. The cross-tab will then display the whole text.
        
      cross-tab - 03.png

Keywords

cr, xtab, crosstab, cross-tab , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Product Enhancement

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020