Unable to retrieve data for the report. Error Details – The conversion of a nvarchar datatype to a datetime datatype results in an out-of-range value

(0) Share

Report

Posted on by Community Member

We are in the process of evaluating POS 2009. Installed under SQL 2008 on Windows Server 2008, as well as 2 clients 1 on XP and the other on Windows 7 Pro. All machines fully service packed and with latest updates. We can run only a handful of the 50+ standard reports in POS 2009. No sales reports work at all. We constantly get the error -

Unable to retrieve data for the report. Error Details – The conversion of a nvarchar datatype to a datetime datatype results in an out-of-range value

We have checked regional settings and all are set correctly for UK. Any thoughts would be helpful.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

Re: Unable to retrieve data for the report. Error Details – The conversion of a nvarchar datatype to a datetime datatype results in an out-of-range value

Bizarre workaround discovered. If you change the settings in Control Panel to English (US) rather than English (UK) and then modify the formats for date and currency within the English US settings, the reports work (but show $ as the amounts rather than £'s). I have set up a 1 to 1 exchange rate for $'s to £'s so the only thing that is not right is the currency symbols in the reports. The register shows £'s. How very strange - this issue needs to be dealt with by Microsoft

Was this reply helpful? Yes No
Jeff @ Check Point ... 13,382 on at

Like (0)

Report

Re: Unable to retrieve data for the report. Error Details – The conversion of a nvarchar datatype to a datetime datatype results in an out-of-range value

Bill,

Are you sure you're using the UK version of POS2k9 and not the US version? They are different so I'm told, but we don't use/sell/support the product.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Unable to retrieve data for the report. Error Details – The conversion of a nvarchar datatype to a datetime datatype results in an out-of-range value

Hi Jeff - thanks for responding. Shortly after we discovered the 'bizarre workaround' we found there was such a thing as the UK version (not from MSDN where we originally downloaded it). We applied that and all ills with reporting were 'cured'.

Was this reply helpful? Yes No
Dan Trotter 20 on at

Like (0)

Report

Re: Unable to retrieve data for the report. Error Details – The conversion of a nvarchar datatype to a datetime datatype results in an out-of-range value

Hi Bill, I haven't gotten the workaround to work.. around,. .but I'm keen to know where you sourced the UK version from. I too got my POS2009 direct from Technet for eval, and am having the same issues. I had always suspected something to do with the regional date variations from US to UK, but didn't know if it was a SQL based issue that I would have had to change

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Unable to retrieve data for the report. Error Details – The conversion of a nvarchar datatype to a datetime datatype results in an out-of-range value

You get the UK version from here:

mbs.microsoft.com/.../POS2009NFR.htm

(You will need to sign in as a partner)

Was this reply helpful? Yes No