1. From Analysis, click Query
  2. Click Add ad-hoc query
  3. Select Revenue as the query type
  4. On the Select Filter and output fields tab, drag Transaction Type to 'include records where'
  5. Select one of recurring gift, pledge.
  6. In the same middle section, scroll down to Credit card section
  7. Drag Card number on to 'include records where' select Not Blank
  8. Add any additional fields to the output, like Constituent Name and credit card expires on
  9. Click Preview Results