I'm looking to create a report based on a found set. Essentially, I have a field that indicates whether an event needs a piano (::Piano) and is a simple checkbox number field. I'd like to create a report that only shows events which need pianos and then additionally list the piano that is needed. This is tricky because pianos are listed as a type of resource in an inventory table. So the report would need to a) find only records that need pianos and b) only list resources of type "piano."
I hope this makes sense. Any help you can give is appreciated!