Reportsmith fields displaying 0 values

[eletuw]

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.

 

[CharlesCook]

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.

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[eletuw]

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.

 

[FireGeek21]

Is your version of Report Smith compatable with SQL Server 2008?