The ReportHideRowOrColumn function will hide a designated row or column when triggered upon a designated event. If a cell within the defined range = “hide”, the function will hide that row or column when triggered. If the defined range is a single row, the function will hide the column. If this range is a single column, the function will hide the row.
Typically this function is used to hide data that is impertinent to the current purpose of the report and/or filters being used. For example, a user can set up a report to hide invoices with zero balances or to show only accounts with a delinquent status, etc. (Note: the rows/columns are not actually hidden in the sense that Excel hides them. They are hidden from view by setting their width/height to 0. A user can simply expand the hidden rows by expanding the width.)
A pull or save action are designated as the run event.
A run event (defined in OnPullSaveOrBoth) will trigger this function being ran.
A cell value of “hide” in the range C47:48 will hide that row when triggered.
This function will run.
Trigger Combination List
The execution of this function is determined by a combination of an Interject action and an Interject event. An action is a pull or save action whereas an event is a clear or run event. The values in the OnPullSaveOrBoth and OnClearRunOrBoth arguments will determine what actions/events trigger the function’s execution.