A user needs to be able to change the schedule of a report which was originally scheduled by another user. Since users can only see reports they themselves scheduled (unless they’re in the admin group), this doesn’t appear to be possible. So the question becomes is there a way to reassign a scheduled report to someone else, or is our only option to delete the schedule and recreate it?
I can always change it as System Admin, but I’d love for this sort of thing to be self-service.
Thanks!
Jeanne
Jeanne DeVore | Technology Manager Chicago Shakespeare Theater
312. 667.4943 direct line | 312.403.0314 mobile | www.chicagoshakes.com | facebook | twitter 800 East Grand Avenue on Navy Pier | Chicago, Illinois 60611
Brilliant, Fernando, that worked a treat! Thanks so much.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Fernando Margueirat Sent: Thursday, October 22, 2015 2:03 PM To: Jeanne DeVore Subject: RE: [Tessitura Technical Forum] Reassigning a scheduled report
I’m not sure if this works, but you can try it in test.
· Find the id for the report request linked to the schedule (SELECT request_id FROM gooesoft_report_schedule WHERE name = ‘the name of your schedule’)
· Change the user id for the report request (UPDATE gooesoft_request SET user_id = ‘new user’ WHERE id = the id you find in the step above)
Fernando Margueirat Senior Business Analyst The National Ballet of Canada 470 Queens Quay West Toronto, Ontario M5V 3K4 P: 416 345 9686 x453 F: 416 345 8323
http://national.ballet.ca
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jeanne DeVore Sent: Thursday, October 22, 2015 1:55 PM To: Fernando Margueirat <FMargueirat@national.ballet.ca> Subject: [Tessitura Technical Forum] Reassigning a scheduled report
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!
One idea that was used at a previous organization I was at was to have a login that was specifically for scheduled reports. That way it lives forever and anyone could access that login to setup scheduled reports or adjust scheduled reports as needed. No need to worry about reassigning them or remembering who in fact had the scheduled report if someone left the organization.
Chris
Unknown said: One idea that was used at a previous organization I was at was to have a login that was specifically for scheduled reports. That way it lives forever and anyone could access that login to setup scheduled reports or adjust scheduled reports as needed. [...]
One idea that was used at a previous organization I was at was to have a login that was specifically for scheduled reports. That way it lives forever and anyone could access that login to setup scheduled reports or adjust scheduled reports as needed. [...]
We do the same here for any long-scheduled report, particularly daily ones: they are sent to a distribution list in Exchange, that can be easily updated (relative to report server gyrations) as staff comes and goes or distribution needs change.