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

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016 

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 BusinessViews Manager , Product Enhancement

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016