I am not always able to run a campaign analysis on the first day of the month before any other transactions have been entered.  The query I create uses an end of month date but when used with the campaign analysis report it doesn't give me an end of the month balance for a campaign.  The raised, received and pledged totals all generate from the query but the balance is not.  It is "to date" total.    See Case 017585671 for additional details.