You can effectively hide tabs, which are referred to as worksheets, in your Jet Reports by adding a specific keyword to cell A1 of the desired sheet. Jet Reports provides robust functionality to control the visibility of entire worksheets, individual rows, and columns when your report is run, ensuring a clean and focused output.
Hiding Entire Worksheets (Tabs)
To hide an entire worksheet, or "tab," in your Jet Reports, you simply need to specify this instruction within the sheet itself. This is particularly useful for sheets that contain intermediate calculations, raw data that shouldn't be seen by end-users, or sensitive information you wish to conceal in the final report.
- Method: Place the text
+HideSheetinto cell A1 of the worksheet you intend to hide. - Action: When you run the report, Jet Reports will automatically hide this specific worksheet, making it invisible to anyone viewing the completed report.
This ensures that only the relevant summary or presentation sheets are visible, streamlining the user experience and maintaining data privacy.
Hiding Rows and Columns
Beyond entire sheets, Jet Reports also allows for granular control over the visibility of rows and columns. This is useful for temporary data, report builder notes, or detailed breakdowns that are necessary for the report generation but not for the final view.
Here's how to hide specific rows and columns:
- Hiding a Column:
- Insert the keyword
Hideinto Row 1 of any column you do not want displayed. For example, if you want to hide column C, typeHidein cell C1.
- Insert the keyword
- Hiding a Row:
- Insert the keyword
Hideinto Column A of any row you do not want displayed. For example, if you want to hide row 5, typeHidein cell A5.
- Insert the keyword
When the report is executed, Jet Reports will process these instructions and hide the specified rows and columns from the final output.
Summary of Hiding Methods in Jet Reports
For a quick reference, here's a table summarizing the hiding techniques:
| Element to Hide | Keyword/Method | Location | Purpose |
|---|---|---|---|
| Whole Sheet | +HideSheet |
Cell A1 of the worksheet | Conceal entire tabs (worksheets) from the final report. |
| Column | Hide |
Row 1 of the column | Hide specific vertical data ranges. |
| Row | Hide |
Column A of the row | Hide specific horizontal data ranges. |
Practical Applications and Best Practices
- Cleaner Reports: Hiding unnecessary sheets, rows, or columns leads to more professional and easier-to-understand reports for your audience.
- Data Security: Conceal sensitive information or intermediate calculations that are not meant for general viewing.
- Streamlined Development: Keep all your calculations and supporting data within the same workbook during development, then easily hide them for final distribution.
- Automated Process: The hiding process is fully automated by Jet Reports when the report is run, requiring no manual intervention after setup.
By utilizing these simple yet powerful keywords, you can precisely control the presentation of your Jet Reports, ensuring that your audience sees only the most relevant and polished information. For further detailed documentation and advanced features, you can always refer to the official Jet Reports Documentation.
