On our till we have a list of members. There is a report that gives you all of the members. I need a report that tells me which members have paid there membership. How do we do this.

Not sure if this works but you can constrain your report where entity type fields equals “whatever”. Example (EC.Blocked="No") [Non-Blocked Customers:2,2,1,1] >Name|Address|Phone|Balance {REPORT ENTITY DETAILS:EC.Membership Number.asc,EC.Membership Type:(ET=Customers) && (EC.Blocked="No")}