Hi Folks,
I have a repeating group with columns of a data type called “Items” across the top. I’m populating that with a Search for Items that returns all Items in my DB.
Rows in my repeating group are populated with data in two states I created on the page: Transactions and Time Activities. These are lists that may reference an Item in my database. The Items in the states will appear more than once on separate rows.
I am grouping these into Accounts that are also part of the row data. I sum their Amounts to report a single number for a single account in a single item. An Item may appear in either or both states, so I need to test both to make sure I capture all Items with an Amount.
The problem I have is that since I am searching for all Items, any Item that is not in one of my states appears with blank data for the entire column. I want to update the search rather than try to hide columns as I think that will make the page load faster.
How can I fetch the items that appear in the states so I only show the columns containing items at the top and in my data in the table?
I’ve posted a screenshot below with the columns I want to remove.
Thank you!
