SAP Knowledge Base Article - Public

1286945 - How to suppress the column headers of a cross-tab from the second page in Crystal Reports?

Symptom

  • How to not show the cross-tab headers from the second page, in Crystal Reports?
  • How to print the cross-tab column headers on the first page, and suppress it from the second page onwards?
  • When suppressing the cross-tab column headers, the text is suppressed, but it keeps showing the borders of the cross-tab grid. How to remove it?

Environment

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

Resolution

  • There is no option in a cross-tab to hide it's headers from the second page.
          
         
  • A workaround will be to use a copy of the cross-tab to display the column headers, and then suppress the column headers of the orginal cross-tab:
             
    1. Open the report in Crystal Reports.   
            
        
    2. Use a copy of the cross-tab to be used as the cross-tab columns
         
      1. Create a section above the current cross-tab.  
           
      2. Set the new section to print at the same time as the next section, by selecting the section option "Underlay Following Sections"
            
      3. Copy the cross-tab to the new section.
          
      4. Remove the fields used for the rows on the cross-tab.
          
        4.1  Right click on the cross-tab, and select "Cross-Tab Expert"
        4.2  In the "Cross-Tab Expert" window, under the tab "Cross-Tab", remove the fields used in the Cross-Tab rows.
        4.3  Click "OK" to accept the change.
              
      5. Suppress all the cells of the cross-tab, except the column headers cells.
         
        5.1  Right click on a row cell of the cross-tab, and select "Format Field...."
        5.2  In the "Format Editor", under the tab "Common", check the option "Suppress"
        5.3  Click "OK" to accept the change.
        5.4  Repeat step 5.1 to 5.3 for each cell of the cross-tab, except for the column headers cells.
            
      6. Suppress the cross-tab grids for the whole cross-tab, except for the column headers.
          
        6.1  Right click on the cross-tab, and select "Cross-tab Expert"
        6.2  In the "Cross-Tab Expert" window, select the tab "Customize Style"
        6.3  Click on the button: "Format Grid Lines"
        6.4  In the "Format Grid Lines" window, select a lines, and uncheck the option "Draw"
        6.5  Repeat the same step for each line, except the lines for the column headers.
        6.6  Click "OK" to accept the change.
        6.7  Back to the "Cross-Tab Expert" window, click "OK"
                  
         
    3. On the original cross-tab, suppress the column headers of the cross-tab
        
      1. Suppress all the column headers cells of the original cross-tab.
         
        1.1  Right click on a the column header cell of the cross-tab, and select "Format Field...."
        1.2  In the "Format Editor", under the tab "Common", check the option "Suppress"
        1.3  Click "OK" to accept the change.
        1.4  Repeat step 1.1 to 1.3 for each cell of the cross-tab, except for the column headers cells.
         
      2. Suppress the cross-tab grids for the original cross-tab column headers.
          
        2.1  Right click on the cross-tab, and select "Cross-tab Expert"
        2.2  In the "Cross-Tab Expert" window, select the tab "Customize Style"
        2.3  Click on the button: "Format Grid Lines"
        2.4  In the "Format Grid Lines" window, select each of the following lines, and uncheck the option "Draw"
               - Column labels on top border
               - Column label left border
               - Column Labels vertical lines
               - Column label right border
            
        2.6  Click "OK" to accept the change.
        2.7  Back to the "Cross-Tab Expert" window, click "OK"
            
          
    4. Align both cross-tabs, so the column headers shows correctly above each of the corresponding columns.
                
                
  • For a sample report, showing the above technique, see the "Attachments" section of the SAP Knowledge Base Article.

Keywords

Hide, Display, Show, 2nd page, cross tab, crosstab, xtab, x-tab, CR , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

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

Attachments

Cross-tab - Suppress Headers.rpt