Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reportsmith fields displaying 0 values

Status
Not open for further replies.

eletuw

Programmer
Sep 15, 2000
15
GB
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.
 
I would make a copy of the report. Then I would try doing a table replace for each table against sql server 2008 in 2000 compatibility mode.

Specializing in ReportSmith Training and Consulting
 
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.
 
Is your version of Report Smith compatable with SQL Server 2008?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top