AnsweredAssumed Answered

Report based on found set

Question asked by apaulg on Oct 2, 2018
Latest reply on Oct 2, 2018 by apaulg


Hi all,

 

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!

Outcomes