# Report Designer: Showing hidden rows

Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Workpapers CS phone support is available on that date from 9 AM - 5 PM ET.

It may be necessary at times to insert rows that are required for calculations in a report or financial statement but to hide those calculation rows when printing or previewing. You can mark rows to be hidden by setting the row height to zero in the design grid. This causes the application to execute the calculations, but the calculation rows will not appear when the report or statement is printed or previewed on the screen.

This topic describes how to view information that is contained in hidden rows. In the following example, rows 4, 7, 9, and 11 are all hidden in the the Income Statement - Current Period - Percent - Current Year - Percent financial statement.

Show design grid

## Show rows

1. To select all the rows, including those that are hidden, click the row number button in the design grid above the hidden row(s), and then drag the mouse pointer to the next row below the hidden row(s).

2. Right-click and choose Row Height..., and then click OK to unhide the row(s) that were previously hidden.

• Row 4 contains the total sales for calculating the percentages in columns D and H.

See also: Report Designer: Formulas not working correctly due to cell referencing.

• Rows 7 and 9 are spacer rows used to separate rows 6 and 8 into unique repeating levels.
• To include an underline in a hidden row, be sure to set the height of the row to 0.01 to reveal the underline and minimize the blank space in the row. As seen in the example above, row 11 is not completely hidden with a row height of zero.

## Hide rows

1. Click the row number buttons to select the row(s) to be hidden.

Note: To select multiple rows, press SHIFT+CTRL on your keyboard.

2. Right-click in a selected row and choose Row Height..., change the row height to 0.00 and click OK.

Related topic: Reporting and Report Designer: Procedures