Bryan and I got on a Zoom session and worked on a dynamic sub inventory report. Last time we had talked about taking over the numbering system and passing in hidden counters behind the scenes. This was going to help us be more dynamic and even allow us to group like sub attribute names (from different item categories). He had gotten that done and it was looking great. We then rolled into the output and/or search results. We were getting results but it was pulling in more data and values then was needed. We spent most of the session talking about how to show/hide columns dynamically.

As a side note, we do tons of this on the flex grid tie-in reports and output. The flex grid table has over 70 data columns but sometimes we only show 4 or 5 columns based on data that is stored. We end up converting all output to numeric lengths, blanks are a 0 length, and valid data is converted into a length or number. We then watch for columns that have a positive length (sum up the column lengths). With the correct logic in place, we can virtually show/hide all of the other columns until they have valid data in them. Anyways, we were working on similar type dynamics for sub inventory attributes and whether or not to show/hide certain columns in the output report.