Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

Automatic Hidden Columns, Sheets and Rows


Overview

Sometimes, it can be very convenient to include information in your report, but not actually display it.

Example

The NF function uses a record key (returned by the NL function with the blank Field parameter) to retrieve fields, but a record key itself does not display useful information so it may be useful to hide columns that contain record keys.

hide01.png

 

You can use the Hide keyword in Row 1 of any column you do not want displayed, or in column A of any row you do not want displayed. 

hide03.png

To automatically hide whole sheets, you can add +HideSheet to cell A1 of a worksheet. 

hide02.png

When you run the report, Jet Reports will hide the rows, columns, or sheets that you have specified.

Automatically hidden rows, columns, and sheets provide an easy way to hide calculations on the final report.  In Design Mode those rows, columns and sheets are visible so you can make changes to the report structure.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments