v10.0 Performance Report

While we’re on the subject of fixes…

There’s a line of code in the new Performance Report that essentially turns the Performance End Date parameter into the Performance Start Date, so that it will only report on a single day, no matter what you do. So if your Development Department uses this report, change this:

Select @p_end_dt = dateadd(ms, -3, dateadd(dd, 1, cast(floor(cast(max(@performance_sdate) as float)) as datetime)))

Into this:

Select @p_end_dt = dateadd(ms, -3, dateadd(dd, 1, cast(floor(cast(max(@performance_edate) as float)) as datetime)))

Thanks for all of your replies to the previous post. I look forward to the patch!

Rey

--

A. Rey Pamatmat

Tessitura Manager

The Public Theater

425 Lafayette Street

New York, NY 10003

(212) 539-8739

rpamatmat@publictheater.org

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!

While we’re on the subject of fixes…

There’s a line of code in the new Performance Report that essentially turns the Performance End Date parameter into the Performance Start Date, so that it will only report on a single day, no matter what you do. So if your Development Department uses this report, change this:

Select @p_end_dt = dateadd(ms, -3, dateadd(dd, 1, cast(floor(cast(max(@performance_sdate) as float)) as datetime)))

Into this:

Select @p_end_dt = dateadd(ms, -3, dateadd(dd, 1, cast(floor(cast(max(@performance_edate) as float)) as datetime)))

Thanks for all of your replies to the previous post. I look forward to the patch!

Rey

--

A. Rey Pamatmat

Tessitura Manager

The Public Theater

425 Lafayette Street

New York, NY 10003

(212) 539-8739

rpamatmat@publictheater.org

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!