I have a report that displays numbers correctly when run against sql server 2000 but when run against sql server 2008 in 2000 compatibility mode, the numbers are displayed as 0. The report query actually returns numbers.
Any help will be greatly appreciated.
Thanks Charles for your response as usual. I actually found out that the problem is due to this error:
"conversion failed when converting date and/or time from character string"
The error came up when I tested the selections on the selections tab of the report. The database is already in 2000 compatibility mode. How do I resolve this issue?
I also copied the sql to QA and tried it and got the same error message when checking syntax.
Thank you.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.