Overview

Using Velixo's Hide Zero Columns feature makes your reports tidier and more readable by automatically hiding columns that only have zero values.

Basic Hiding

To use this function, just select a range of columns, an individual row or multiple rows and click Hide Zero Columns:

Velixo Reports will automatically hide all columns where every selected column in your selection is zero. Empty columns are ignored to ensure the layout of your report is not impacted.

To show all rows and columns that are hidden use Unhide All:

To show columns that are hidden, press Ctrl + Shift + 0 or use the Unhide command in the Excel contextual (right-click) menu:

You can also use the Format menu in the Cells section of the Home tab in the ribbon:

When using basic hiding, you need to manually unhide the columns before refreshing your report and then re-hide those columns that now contain the zero values you do not want to see.

Auto Hiding allows you to set your hiding criteria and then have Velixo Reports remember that and automatically hide zero columns and un-hide non-zero columns when your report is refreshed.

The Auto Hide/Unhide feature is accessed through the pull-down on the Hide Zero Columns button:

Example:

Here is an example of the results of using the Auto Hide/Unhide Columns feature:

In the example, the original report show some zero values in row 8.  By selecting that row and then clicking Auto Hide / Unhide Columns in Selected Range from the Acumatica ribbon, the zero-value columns in that row are hidden.  (Velixo Reports will now remember the area to which you want to apply this hiding criteria.  This area is referred to as the "Controlled Range")

Next, when the report is changed with new data (as shown by the change in column K), Velixo Reports automatically adjusts which columns are hidden, based on the new values in the report.

Auto Hide FAQ: