Can anyone help please?  I am writing a crystal report from an Event Participation export from Raiser's Edge which includes Registration Fees and Other Donations.  The report is grouped by Event with summaries for total participants, total donations and registration fees, the first two summaries return correct totals but the one for Registration Fees is completely wrong e.g. for the London Marathon our total registration fees are approximately just over £6,000, as reported for Raiser's Edge itself, but I am getting a figure of just over £79,000.  As a footnote all the table links are all outer joins rather than inner, I had to do this to ensure all Events appeared in the report even though some of them had blank data  in Participant numbers and other fields.

 Thank you

Colin Grove

Hi Colin,

We have different reports for different registration types. In the meantime Crystal doesn't like blank fields. You have to use the following formula to correct this If not IsNull(field name) then {field name} else 0 otherwise you may not get the correct totals.

Another  thing is you may want to look at the function of do not repeat if duplicated. If you have more than one registration fee on an account, since payments aren't linked to a registration fee they can show up twice.

Example:

Registration Fee: Sponsorship: $2500

Registration Fee: Golfers: $500

if you received a payment of $3,000 it would show $3,000 twice - next to each reg fee.