Using Integer dataType parameter in script

Rajesh Kakawat

Can I use parameter of Integer type in script on beforeOpen event of dataset.
I am using Birt report with hibernate and Sql server 2005 as database.

Becoz when I use patientType paramter as Integer then I am getting error
but when used it as String type ,report is working perfectly

Error I am getting is:

org.eclipse.birt.report.service.api.ReportServiceException:Error happened while running the report


My script content is as follow:

queryString=this.queryText;
if(params["patientType"].value)
{
newString = " and patient.patientType = " + params["patientType"];
queryString=queryString + newString;
}
this.queryText=queryString;

mwilliams

Hi Rajesh007,

Try:

params["patientType"].toString() when building the query string. See if that works.