string parameter to integer

Shoaib Bagwan

can somebody please help me ..<br />
i am passing string to the report parameter for "WHERE IN CLOUSE" BUT RESULT NOT AS EXPECTED...<br />
MY REPORT IS struct is as FOLLOWS...<br />
<br />
<span style='color: #FF0000'>VEHID = (4125,5623,4536,1234,5896)</span> which i got from session.getAttribut() on my .jsp page<br />
<br />
m passing this veh id when i m calling .rptdesign as<br />
<span style='color: #FF0000'>/./frameset?__report=vehMasterReportFBirt.rptdesign&VehId="+VEHID+"<br />
</span><br />
i have one report parameter as "VehId" as shring and empty default value<br />
also i have one query parameter "VehId" as shring and which is linked to report parameter <br />
<br />
my QueryText is as....<br />
<span style='color: #FF0000'>select * from db_gps.t_VehMst where Status = 'Active' AND VehId IN (?)</span><br />
which result in error and if i made some changes it gives result for first value only <br />
<br />
how can i get vehid list in "Where in clouse" of the reports querytext........<br />
.please suggest the ways to complete my report<br />
<br />
:mellow: <br />
<span style='color: #8B0000'>thanks</span>

Hans_vd

Please, follow this link:

http://www.birt-exchange.org/org/devshare/designing-birt-reports/771-using-a-multivalue-parameter-in-a-in-clause/