• Replies 4 replies
  • Subscribers 412 subscribers
  • Views 37 views
  • Users 0 members are here
Related

Event Report - Excel issues!

Former Member
Former Member $organization

Hi all,

We're running our first elevated event and we're having problems exporting to excel. We're not receiving the names of the guests, just the name of the event itself in the first column. In Tessitura, the report looks fine but we'd like to export to excel to be able to manipulate the data as we'd like.

Any ideas on why the guest_names aren't showing up?

Thanks!

Parents
  • $organization

    We just had our elevated event and we used the Event Listing Report and  in column H it has guest names.

    Melissa

     

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Beth Gilliland
    Sent: Wednesday, October 02, 2013 3:56 PM
    To: Melissa Malone
    Subject: Re: [Tessitura Development Forum] Event Report - Excel issues!

     

    Lesley -

    The standard Tessitura report doesn't pull at the "guest" level, only at the (as we call it here) "host" level.

    We made our own custom SSRS report to pull data at the guest level - then it exports for excel. We even have a Word name tag template that merges with the excel import making name tags MUCH easier - and the data gets into Tessitura first!

    Let me know if it's something you might be interested in...

    Beth

    From: Lesley Lewis <bounce-lesleylewis4764@tessituranetwork.com>
    Sent: 10/2/2013 5:05:58 PM

    Hi all,

    We're running our first elevated event and we're having problems exporting to excel. We're not receiving the names of the guests, just the name of the event itself in the first column. In Tessitura, the report looks fine but we'd like to export to excel to be able to manipulate the data as we'd like.

    Any ideas on why the guest_names aren't showing up?

    Thanks!




    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!



    This email and any attachments may contain confidential material and is solely for the use of the intended recipient(s). If you have received this email in error, please notify the sender immediately, delete this email, and do not use, retain or disclose any information contained in this email. Any views or opinions are solely those of the sender and do not necessarily represent those of the Los Angeles Philharmonic Association. The LA Philharmonic does not guarantee that this email or any attachments are free from viruses or 100% secure. Unless expressly stated in the body of the text of the email, this email is not intended to form a binding contract.
Reply
  • $organization

    We just had our elevated event and we used the Event Listing Report and  in column H it has guest names.

    Melissa

     

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Beth Gilliland
    Sent: Wednesday, October 02, 2013 3:56 PM
    To: Melissa Malone
    Subject: Re: [Tessitura Development Forum] Event Report - Excel issues!

     

    Lesley -

    The standard Tessitura report doesn't pull at the "guest" level, only at the (as we call it here) "host" level.

    We made our own custom SSRS report to pull data at the guest level - then it exports for excel. We even have a Word name tag template that merges with the excel import making name tags MUCH easier - and the data gets into Tessitura first!

    Let me know if it's something you might be interested in...

    Beth

    From: Lesley Lewis <bounce-lesleylewis4764@tessituranetwork.com>
    Sent: 10/2/2013 5:05:58 PM

    Hi all,

    We're running our first elevated event and we're having problems exporting to excel. We're not receiving the names of the guests, just the name of the event itself in the first column. In Tessitura, the report looks fine but we'd like to export to excel to be able to manipulate the data as we'd like.

    Any ideas on why the guest_names aren't showing up?

    Thanks!




    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!



    This email and any attachments may contain confidential material and is solely for the use of the intended recipient(s). If you have received this email in error, please notify the sender immediately, delete this email, and do not use, retain or disclose any information contained in this email. Any views or opinions are solely those of the sender and do not necessarily represent those of the Los Angeles Philharmonic Association. The LA Philharmonic does not guarantee that this email or any attachments are free from viruses or 100% secure. Unless expressly stated in the body of the text of the email, this email is not intended to form a binding contract.
Children
  • $organization in reply to Melissa Malone

    Melissa -

    You're right - I should have been more clear. :)

    We have other data tied to the guest that we want to pull that isn't on the standard report - which is why I think of that as the "host level" and our custom one as the "guest level". Sorry for any confusion. 

    Also, I believe if you "save to list" from the standard report, it only gives you the "host" customer IDs. We required the guest IDs, so that is how our custom report is set up. 

    (I haven't run the standard report in a long time, and I'm not in front of my machine right now, so I apologize for any misgivings about the standard report...)

    Beth

  • Former Member
    Former Member $organization in reply to Beth Gilliland

    Thank you both so much! We feel a bit silly as the info was there all along. The way it exported to excel made one of the columns really wide and we didn't scroll all the way. Lesson learned!

    Thanks!
    Lesley