Donations associated with ticket purchases

We are currently trying to run some reports that connect donations made at the time of ticket purchases.  It seems that they are not connected after the gift is made.  Has anyone else had this issue, and how did you amend this issue?  We are trying to determine which shows generate the most donations and are unable to run a report with this information.  In order to do this, we have to do a ton of manual manipulation of the data and guessing.

Thank you for your assistance!  Angela