Hello,
We have a custom SSRS version of the Ticket Sales by Period report that we are having trouble with when running it as a scheduled report.
The report server seems to process the report, but fails to send an email when either one of two seasons are selected in the parameters. Also, the report does not show up in the 'View Reports' area.
The report runs perfectly with those seasons when run from within Tessitura, and also runs perfectly when the selected output for the schedule is 'data center'.
The issue occurs when selecting any of the 'Email as' output options selections. The report runs fine when scheduled for any other season. Anybody have ideas about this one?
Thanks!
Jeff
Unknown said: The report runs perfectly with those seasons when run from within Tessitura, and also runs perfectly when the selected output for the schedule is 'data center'. The issue occurs when selecting any of the 'Email as' output options selections. The report runs fine when scheduled for any other season. Anybody have ideas about this one?
We used to have this issue. Please see this thread:
http://www.tessituranetwork.com/Community/forums/p/8099/27220.aspx#27220
...particularly Beth Gilliland's post of Dec 12 2012 12:11 PM.
Thank you Chris. Unfortunately those ideas do not apply to our situation, as scheduled SSRS reports run and email just fine, except for this one. The report in question only fails to email when it is scheduled to run against one of two specific seasons. Otherwise it runs and emails correctly.
Weird. Are your seasons control grouped?
Yes, they are control grouped, but the control groups are correct and match other seasons that the report works for.
We had an issue like this a few months ago. Tessitura support finally sussed out that it was a link in the report causing it. I had added code to make the constituent number clickable to take you to the patron record.
Not sure if you have that in your report. But if you do, try removing it and seeing if the scheduled report works?
- Levi
Yet another good thought, but there are no links in the report. I was finally able to trace it down to one production season that is making it bomb. Not sure what the issue is yet, but at least it's a start. Thanks for the input!