The following query will get you pledge information for pledges that have not been paid off yet. The query is built to give you pledges per a date range, to a fund(s) and to specific OBO's. A couple things about this query, you can add additional fields to this query to get family information, but you will want to have the pledge information remaining at the beginning of the query. Secondly, you can choose to not have this per organization or per fund if you would like, just take those conditions out of the query. Please see the picture below on how to build this query.