I have a report that can take anywhere from 5-30 minutes to run. The results are displayed in a listview. The results are inventory items that either "Pass" or "Fail" a "quantity on hand vs. sales per month" test (basically, do we have enough widgets in stock based on past sales averages).
Since the results can contain up to 4000 items it would be nice to toggle three displays:
1. All Items that Pass
2. All Items that Fail
3. All Items Regardless
Right now it shows all items, I simply change a subitem in the listview to say Pass or Fail and change the color to red if its a fail.
Is it possible to hide or toggle the results to display like this?
Thanks for your help!!!