PSA L&P - Reports: Error | No report data to render ...Query execution failed while retrieving data for report. The exact error message is: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

No report data to render ...Query execution failed while retrieving data for report. The exact error message is: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

This error is caused by using a non-existent date in either of the custom date range fields. Using a date of September 31, April 31, June 31, or November 31 will cause this issue since each of these months have fewer than 31 days. Using February 29th in a non-leap year will cause this error too. 
custom_date_range.png

When the Preview Report or View PDF buttons are selected at the bottom of the Configure Report screen, a blank page will display with this error message as shown here. 
no_report_data_to_render.png

 

 

 

 

 

 

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request