200
When trying to run a z report on pos 2009 we are getting an error ' A server failure occurred while calculating the hourly sales'.
Everything else is working fine, the store can process sales and are getting receipts etc, but just cannot do a z.
They are on POS 2009 with SP1 using SQL 2008
*This post is locked for comments
Just so that other people can resolve this issue. This happens with X,Z,ZZ and any other the manager view reports when SQL Server CLR is disabled
You will need to run the following query, from management studio, of manager view -> database tools
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,403
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
