1.     In query, create a new gift query with Format of Dynamic

    2.     On the General Tab under criteria, create the following criteria

    Campaigns, Campaign ID = {your campaign ID}
    AND Gift Information, GIft Type = Pledge
    AND Gift Information, Pledge Balance = 0

    3.     Save and close this query 

    4.     Create a new Campaign Report from Reports, Pledge and Recurring Gift Reports

    5.     On the General tab, Include Selected Records, and use the query from step #4

    6.     On the General tab, mark checkboxes such as Include inactive, deceased or constituents with no valid address. Leave all other tabs set to the Default

    7.     Click Preview