Calling procedure using session param & report param

sonimanish

Dear all,

i am using Birt report using stored procedure.
in that proc i have 8 param.
3 are from session and remain from report.

Please let me know to pass all param

i use like this but not working its throughing error that param 1,2,4,5,6 can set null

thanks


importPackage(Packages.au.com.pepsico.birt.data);
importPackage(Packages.javax.servlet.http);
importPackage(Packages.javax.servlet);

var QueryString;
var request = reportContext.getHttpServletRequest();
var session = request.getSession();
var UserID1 = session.getAttribute("Userid");
var Groupid1 = session.getAttribute("Groupid");
var roleID1 = session.getAttribute("roleId");

QueryString=this.queryText;
QueryString="{call Proc_test(?,?,"+Groupid1+",?,?,"+UserID1+",?,"+roleID1+")}";
this.queryText=QueryString;