In a subreport I have a column of data in a group called giftype. In select expert, I filtered out all giftypes that <> pledge or writeoff. This will give me ALL pledges and writeoffs in the following sample order:
Type Giftsumkey Amt
pledge transaction 1090 250
pledge transaction 3090 15
pledge transaction 1555 750 (want to show this)
writeoff transaction 1555 (250) (want to show this)
pledge transaction 5244 50
pledge transaction 4254 144
In this case the I only want to show the data if the pledge transaction had an accompanying writeoff transaction. in this case I want to show the entry with the giftsumkey of 1555 only. In this case, the giftsumkey for the pledge transaction would equal that of the writeoff. How would I filter out the pledge information that did not have an accompanying writeoff?
Type Giftsumkey Amt
pledge transaction 1090 250
pledge transaction 3090 15
pledge transaction 1555 750 (want to show this)
writeoff transaction 1555 (250) (want to show this)
pledge transaction 5244 50
pledge transaction 4254 144
In this case the I only want to show the data if the pledge transaction had an accompanying writeoff transaction. in this case I want to show the entry with the giftsumkey of 1555 only. In this case, the giftsumkey for the pledge transaction would equal that of the writeoff. How would I filter out the pledge information that did not have an accompanying writeoff?