Hi,
While calling the stored procedure getting error
****org.eclipse.birt.report.engine.api.EngineException: Cannot execute the statement. org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object. SQL error #1:The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. ; com.microsoft.sqlserver.jdbc.SQLServerException: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
In report two parameters are there, one is string other one is integer which is financial year.
Due to above issue my back-end db team updating the stored procedure financial year parameter to string.
User will enter only year like 2017 but I have to pass the value as date to stored procedure by hard coding value of date like 10/1+"Year"(10/1 value is hard coded)and appending the 2017 to parameter and passing to stored procedure.
May I know how we can archive this with example.
