An error ‘Cannot insert the value NULL into column ‘PlayerID’, table Tempdb.dbo #Tmp2’ occurs in the Cash Journal report if any vendors have adjustments made for the year being reported but Issue 1099 for this Vendor is de-selected.
All values from either the Solicitation or Campaign fields appear when the Operator is ‘in the list of’, ‘not in the list of’, or ‘never in the list of’ when the Print Query function is used rather than the values selected by the user.
In Reporting>Edit Criteria, when editing and choosing values for Activities to "Select all Attendance for Activity from the attendance page in the list of", it is possible to have the same value available for selection and included in the criteria at the same time.
Statement of Revenues and Expenditures by Period Produces “Conversion failed when converting date and/or time from character string” error message when opening balances date is set to 9/29/2014 or 9/30/2014.
Error: Unable to load C:\inetpub\wwwroot\mill/reports/default.htm occurs clicking on Reporting in the Millennium Navigator.
You can bypass the message and all reporting does function in new criteria, edit, view, etc.