• <GetStart>
  • CSPro User's Guide
    • The CSPro System
    • Data Dictionary Module
    • The CSPro Language
    • Data Entry Module
    • Batch Editing Applications
    • Tabulation Applications
      • Introduction to Tabulation
      • Parts of a Table
      • Parts of the Table Tree
      • Common Uses of Tabulation
      • Capabilities of Tabulation
      • Creating Tables
      • Formatting Tables
        • Formats for a Part of a Table
        • Formatting Row, Column, or Cell Data
        • Formats for a Table
        • Formats for an Application
        • Formats for Printing
        • Views of Tables
        • How To ...
          • Customize Table Text
          • Hide or Show a Row or Column
          • Hide Rows Containing All Zeros
          • Change the Number of Decimal Places Displayed
          • Add a Footnote (Pagenote or Footnote)
          • Add Header/Footer Text to a Table
          • Add a Subtitle
          • Add Stub Leadering
          • Add Borders
          • Add Reader Breaks
          • Change the Way Numbers are Displayed
          • Change the Automatically Generated Text
          • Change Fonts or Colors
          • Change Indentation or Alignment
          • Add Borders to Cells
          • Make Captions Span Data Cells
          • Reset Format of Table Item to Default
          • Change the Repeating of Boxheads
          • Change Stub Column Position
      • Creating Tables by Geographic Area
      • Printing Tables
      • Tabulation Preferences
      • Saving and Copying Table Data
      • Table Post Calculation
      • Run Production Tabulations
      • Advanced Table Topics
      • Table Tips and Tricks
    • Data Sources
    • CSPro Statements and Functions
    • Templated Reporting System
    • HTML and JavaScript Integration
    • Action Invoker
    • Appendix
  • <CSEntry>
  • <CSBatch>
  • <CSTab>
  • <DataViewer>
  • <TextView>
  • <TblView>
  • <CSFreq>
  • <CSDeploy>
  • <CSPack>
  • <CSDiff>
  • <CSConcat>
  • <Excel2CSPro>
  • <CSExport>
  • <CSIndex>
  • <CSReFmt>
  • <CSSort>
  • <ParadataConcat>
  • <ParadataViewer>
  • <CSCode>
  • <CSDocument>
  • <CSView>
  • <CSWeb>

Hide Rows Containing All Zeros

It is possible to have CSPro automatically hide rows when all the cells in the row contain the value zero. This is useful when many rows in a table will have only zeros and you wish to view only the rows that have non-zero data.

 

Hide when All Cells in Row are Zero in Format (Stub) Dialog Box)

 

To have CSPro automatically hide a row if all values in the row are zero, right-click on the stub for the row and choose "Format (stub)". In the "Format (stub)" dialog, check the box "Hide when All Cells in Row are Zero". When you run the table, the row will be hidden if all cells are zero. To view the row again, in order to able to select it, switch to the design view. To switch to the design view, use Ctrl-D or select "Hidden Parts" from the View menu.

 

You can hide multiple rows if they contain all zeros at the same time by first selecting the rows and then right-clicking and choosing "Format (Stub)" as above. Multiple selection is done in the usual Windows manner by left-clicking the mouse while using the Shift or Ctrl key. Using the Ctrl key adds each cell in the table that is clicked on to the selection. Using the shift key adds all the cells in between the two cells clicked on to the selection.