• Replies 10 replies
  • Subscribers 338 subscribers
  • Views 64 views
  • Users 0 members are here
Related

Report Writing - Who does it?

Kjersten Schladetzky
$organization

I'm looking for some ideas on how you handle custom report writing in your organization as well as what you think are the pros and cons of your chosen model.  So, for example, does 1 person in IT handle all custom reporting needs or do you have a power user in each department that can write reports, but use IT to vet them and move them into the Production system?  Or something else entirely?  

We're tossing around ideas and trying to balance what we expect to be a big desire for more custom reporting quickly vs. the security concerns around having non-IT folks access the database.  

Thanks!

Kjersten Schladetzky
Program Manager, American Museum of Natural History 

Parents
  • Former Member
    Former Member $organization

    We do much the same as Caryl.  Our Database Admin has view (but not edit) permissions to the SQL databases, so she can largely assemble the coding needed, or sometimes she uses Access.  I then tweak her queries into SQL stored procedures and create the Infomaker reports.  We have not used SSRS much yet, but are looking to get active with it next month, and I expect that we will both design the SSRS reports.

     

     

    Penny Tabor

    IT Manager

    Midland Center for the Arts

    Midland, MI 48640    

                                         Comptia                                              

     

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Caryl Jones
    Sent: Tuesday, June 17, 2014 9:29 AM
    To: Tabor, Penny
    Subject: Re: [Tessitura Technical Forum] Report Writing - Who does it?

     

    We have one person in IT (me), who writes actual reports that need to be run via SSRS or Infomaker; but we do have a power user in the Box Office, who has access to SQL and can help out with the adhoc data queries that are one off and can provide the information. This is part of their wider Tessitura support role which includes training etc.

    Caryl

    From: Kjersten Schladetzky <bounce-kjerstenschladetzky9327@tessituranetwork.com>
    Sent: 6/17/2014 8:13:43 AM

    I'm looking for some ideas on how you handle custom report writing in your organization as well as what you think are the pros and cons of your chosen model.  So, for example, does 1 person in IT handle all custom reporting needs or do you have a power user in each department that can write reports, but use IT to vet them and move them into the Production system?  Or something else entirely?  

    We're tossing around ideas and trying to balance what we expect to be a big desire for more custom reporting quickly vs. the security concerns around having non-IT folks access the database.  

    Thanks!

    Kjersten Schladetzky
    Program Manager, American Museum of Natural History 




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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
  • Former Member
    Former Member $organization

    We do much the same as Caryl.  Our Database Admin has view (but not edit) permissions to the SQL databases, so she can largely assemble the coding needed, or sometimes she uses Access.  I then tweak her queries into SQL stored procedures and create the Infomaker reports.  We have not used SSRS much yet, but are looking to get active with it next month, and I expect that we will both design the SSRS reports.

     

     

    Penny Tabor

    IT Manager

    Midland Center for the Arts

    Midland, MI 48640    

                                         Comptia                                              

     

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Caryl Jones
    Sent: Tuesday, June 17, 2014 9:29 AM
    To: Tabor, Penny
    Subject: Re: [Tessitura Technical Forum] Report Writing - Who does it?

     

    We have one person in IT (me), who writes actual reports that need to be run via SSRS or Infomaker; but we do have a power user in the Box Office, who has access to SQL and can help out with the adhoc data queries that are one off and can provide the information. This is part of their wider Tessitura support role which includes training etc.

    Caryl

    From: Kjersten Schladetzky <bounce-kjerstenschladetzky9327@tessituranetwork.com>
    Sent: 6/17/2014 8:13:43 AM

    I'm looking for some ideas on how you handle custom report writing in your organization as well as what you think are the pros and cons of your chosen model.  So, for example, does 1 person in IT handle all custom reporting needs or do you have a power user in each department that can write reports, but use IT to vet them and move them into the Production system?  Or something else entirely?  

    We're tossing around ideas and trying to balance what we expect to be a big desire for more custom reporting quickly vs. the security concerns around having non-IT folks access the database.  

    Thanks!

    Kjersten Schladetzky
    Program Manager, American Museum of Natural History 




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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