# How to Auto-Hide headers

**URL:** <https://community.velixo.com/t/how-to-auto-hide-headers/84>\
**Category:** Q&A\
**Tags:** Acumatica\
**Created:** [December 26, 2024, 7:28am UTC](https://community.velixo.com/t/how-to-auto-hide-headers/84 "2024-12-26T07:28:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mari\_Liis\_Brough](https://community.velixo.com/letter_avatar_proxy/v4/letter/m/59ef9b/32.png) [@Mari\_Liis\_Brough](https://community.velixo.com/u/Mari_Liis_Brough)\
**Post date:** [December 26, 2024, 7:28am UTC](https://community.velixo.com/t/how-to-auto-hide-headers/84/1 "2024-12-26T07:28:21Z")

</div>

Hi  
Looking for an easy way to auto-hide headers.  
In the example below, I have three Account Classes listed, and in the C column, I am using VTEXTSPLIT(AccountClassList()) to list accounts within the account class.  
If this report is run for Branch A, the _Trade and Other receivables_ has an ending balance for one account and therefor the row 30 should be displayed.  
If this report is run for Branch B, the Trade and Other Receivable account class has all zero values and the row 30 to 40 should be hidden from view.  
The Auto\_Hide Rows works well and hides all accounts with 0/nil balances, but it does not hide the account class name (Row 30).  
I ended up adding a formula to check the sum for the account class and return 1 or 0, which works fine. However, I was just wondering if there would be a better/easier way to hide the account class name.

 ![](https://community.velixo.com/uploads/default/original/1X/7af8a1153265ec5df0c404b80c8b399113c4d35e.png)

---

<div class="post-metadata">

**Author:** ![Gabriel](https://community.velixo.com/user_avatar/community.velixo.com/gabriel/32/7_2.png) [@Gabriel](https://community.velixo.com/u/Gabriel)\
**Post date:** [December 26, 2024, 7:57pm UTC](https://community.velixo.com/t/how-to-auto-hide-headers/84/2 "2024-12-26T19:57:27Z")

</div>

Hi Mari-Liis,

The solution you use is what I would have suggested; we skip rows with no formula or value during evaluation of zero rows. I remember migrating a set of spreadsheets from another Excel-based solution and they were using the exact same technique.

As an alternative, if you want to make things very obvious to the user that this is where the show/hide conditions are, you could have a column called “Show/Hide”, which shows either 1 or 0 in the cell. The “Show/Hide” column can be outside the print area or even hidden.

Regards,

Gabriel

---

<div class="post-metadata">

**Author:** ![Mari\_Liis\_Brough](https://community.velixo.com/letter_avatar_proxy/v4/letter/m/59ef9b/32.png) [@Mari\_Liis\_Brough](https://community.velixo.com/u/Mari_Liis_Brough)\
**Post date:** [December 30, 2024, 7:21am UTC](https://community.velixo.com/t/how-to-auto-hide-headers/84/3 "2024-12-30T07:21:43Z")

</div>

Thanks, Gabriel, for replying and for confirming that my way of using 1,0s is the same as you would use.