Inconsistent totals in Event Listing Report

Former Member
Former Member $organization

When we run the Event Listing Report, save it to Excel, and add the totals in the “recd_amt” and 
“num_attendees” columns, we are getting inflated totals for the number of attendees and amount paid. 

For example if a constituent brings 2 guests, we enter the Number of attendees as 3 on the Events screen, along with the amount paid, and then double click and list the guests on the Event Attendees screen.  The Event Listing report displays the correct grand total of 3 attendees when it is viewed onscreen. However, when the report is saved to Excel, that constituent is listed three times, each time with 3 attendees, so that the grand total of attendees under the constituent's name becomes 9.

Is there any way to get the correct totals without having to manually remove the duplicate rows from the Excel report? We often want this report rather than the Special Events Receipt Listing Report, in order to report on guest names and the Notes field.

Any advice would be most appreciated!

Parents
  • In the past I've just replaced the Number of Attendees with a value of 1 in Excel. In your example, we would replace the 3 with a 1. So, each person only counts as one. Primitive, but it gets the job done!
    ________________________________________
    From: Tessitura Development Forum [forums-development@tessituranetwork.com] On Behalf Of Maureen Woodall [bounce-maureenwoodall5912@tessituranetwork.com]
    Sent: Thursday, March 25, 2010 5:38 PM
    To: Cate Czerwinski
    Subject: [Tessitura Development Forum] Inconsistent totals in Event Listing Report

    When we run the Event Listing Report, save it to Excel, and add the totals in the “recd_amt” and
    “num_attendees” columns, we are getting inflated totals for the number of attendees and amount paid.

    For example if a constituent brings 2 guests, we enter the Number of attendees as 3 on the Events screen, along with the amount paid, and then double click and list the guests on the Event Attendees screen. The Event Listing report displays the correct grand total of 3 attendees when it is viewed onscreen. However, when the report is saved to Excel, that constituent is listed three times, each time with 3 attendees, so that the grand total of attendees under the constituent's name becomes 9.

    Is there any way to get the correct totals without having to manually remove the duplicate rows from the Excel report? We often want this report rather than the Special Events Receipt Listing Report, in order to report on guest names and the Notes field.

    Any advice would be most appreciated!



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Reply
  • In the past I've just replaced the Number of Attendees with a value of 1 in Excel. In your example, we would replace the 3 with a 1. So, each person only counts as one. Primitive, but it gets the job done!
    ________________________________________
    From: Tessitura Development Forum [forums-development@tessituranetwork.com] On Behalf Of Maureen Woodall [bounce-maureenwoodall5912@tessituranetwork.com]
    Sent: Thursday, March 25, 2010 5:38 PM
    To: Cate Czerwinski
    Subject: [Tessitura Development Forum] Inconsistent totals in Event Listing Report

    When we run the Event Listing Report, save it to Excel, and add the totals in the “recd_amt” and
    “num_attendees” columns, we are getting inflated totals for the number of attendees and amount paid.

    For example if a constituent brings 2 guests, we enter the Number of attendees as 3 on the Events screen, along with the amount paid, and then double click and list the guests on the Event Attendees screen. The Event Listing report displays the correct grand total of 3 attendees when it is viewed onscreen. However, when the report is saved to Excel, that constituent is listed three times, each time with 3 attendees, so that the grand total of attendees under the constituent's name becomes 9.

    Is there any way to get the correct totals without having to manually remove the duplicate rows from the Excel report? We often want this report rather than the Special Events Receipt Listing Report, in order to report on guest names and the Notes field.

    Any advice would be most appreciated!



    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Children
No Data