Team,
I received a work order request to troubleshoot the Performance by Appeals report. This report does not return any data when required parameters are satisfied however it will return data when the required parameters are satisfied and either a production or performance is selected.
My team would like for data to be returned by selecting an entire season instead of drilling down to the production or performance.
In attempting to figure this out I noticed this report does not have a stored procedure associated to it, rather various a select statements run with variation on the parameters selected. Does anyone have this report with a stored procedure or some variation of it?
Thanks!
Naomi Williams
Database Administrator
505 Deaderick St.
Nashville, TN 37243
615-782-4021 office
505-259-3308 cell
"Do or Do Not there is no try"---Master Yoda
Naomi, in the Version Upgrades and Patches project of TASK, under the 8.0 general release solution (#12), is a file called TessituraStandardReports80.zip. This zip file contains a .pbl with all of the standard report datawindows.
The datawindow name for this report is d_perfs_by_appeal and the report uses a stored query within the datawindow rather than a stored procedure in the database.