Technician report is not working after upgrading to 10.8+

If when you try to open Reports - Technician Report, you see this:

Please check the server's log - launch "eventvwr.exe," and choose the "Application" log - for errors or warnings from the helpdesk app. If you see an error like this:

System.Data.SqlClient.SqlException (0x80131904): The PERCENTILE_CONT function is not allowed in the current compatibility mode.  It is only allowed in 110 mode or higher.

You will need to run the following query on your SQL Server:

ALTER DATABASE JitbitHelpDesk
SET COMPATIBILITY_LEVEL = 110

After that the report should work.

report

Creation date: 10/18/2022 11:48 AM Updated: 10/18/2022 11:48 AM

DataImage23.png

Files		Sort by Name Sort by Date
	DataImage23.png 84 KB

Solving problems with on-premises version of Jitbit Helpdesk ticketing system