sql server - BIRT parameters getting rounded -

I am migrating the BITT report from version 2.6 to 4.4 and are experiencing a very strange problem that is < / P>

As part of the query the BIST parameter is passed, if I pass 1 as the parameter, the query is executed for 0 and if I pass the parameter as 99 or 101 , The query is executed for 100

query - the rhythm Select data from 1 where realID = ?;

Datetime decimal (28,0) for parameters

Using DB is SQL Server 2012

I have logged in the value of the parameters in BITT functions ( Before, before and before the closing) and it always corresponds to the parameter value I have passed.

Please help me understand or tell me in the direction where I am

Any help would be greatly appreciated

Note: If I use string from decimal If I convert the datatype, then it works fine if I pass the parameter as part of the query it works fine but it does not work when the parameter value dynamically re-spaces'? In the query,

You should also log the parameter values ​​in later events. They may in some way be modified earlier in the open event. In my BITT framework, I have defined a function like this:

  afterOpen: function (ds) {log.debug ("afterOpen DS" + ds.getName () + "inputParams =" +. Ds.getInputParameters () toString ()); }  

This function can be called trace.afterOpen. Then I can open it in the data set after this:

  trace.afterOpen (this);  

You can also set BIRT's internal entry to FINEST; This debug will generate load of messages and should include bind variables for each SQL statement which executes AFAIK.