1. 

   ziuras, Member

   Hi,
   I want to see report statistics and I get an error:

   Could not execute the report. There was an error in the report.
   Column, parameter, or variable #1: Cannot find data type date.

   Can you help me.
2. 

   ziuras, Member

   My version: 4.3.0
   upgraded from 3.9.4
3. 

   myDBR Team, Key Master

   Assuming you are using SQL Server 2008 (or earlier). The old SQL Server does not have date-datatype which the report uses. Run the updater the get the latest build which uses datetime instead for older SQL Servers.

   --
   myDBR Team
4. 

   ziuras, Member

   database is Ms SQL 2005

   url before date selection:
   http://report.kmv.local/report.php?r=2&p1=29&m=11&h=323531528a14527afece012d4a22dfc38268fbf1

   url after date selection, press RunReport and error show:

   http://report.kmv.local/report.php?r=2&p1=29&u2=2014.09.19+00.00.00&u3=2014.09.22+15.43.14&m=11&h=323531528a14527afece012d4a22dfc38268fbf1
5. 

   myDBR Team, Key Master

   See the earlier post.

   --
   myDBR Team
6. 

   ziuras, Member

   which post?
7. 

   myDBR Team, Key Master

   Assuming you are using SQL Server 2008 (or earlier). The old SQL Server does not have date-datatype which the report uses. Run the updater the get the latest build which uses datetime instead for older SQL Servers.

   --
   myDBR Team
8. 

   ziuras, Member

   Thanks.
   Now it work.

Reply

You must log in to post.