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.
0 Votes
1 Comments
Gabriel Michaudposted
about 16 hours ago
Admin
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.
0 Votes
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.
0 Votes
1 Comments
Gabriel Michaud posted about 16 hours ago Admin
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
0 Votes
Login or Sign up to post a comment