How to set parameters in Report created through DEAPI

mohit_dev

<p>Hi,</p>
<p> </p>
<p>I want to use parameterised query, where I should be able to set values through URL or JavaScript.</p>
<p>I am using the same example code at <a data-ipb='nomediaparse' href='http://www.eclipse.org/birt/resources/documentation/integrating/DeDemo.java'>http://www.eclipse.org/birt/resources/documentation/integrating/DeDemo.java</a>. </p>
<p> </p>
<p>Also is there a way add drop down to this report which can set the parameters for the report.</p>
<p> </p>
<p>Thanks,</p>
<p>Mohit</p>
<p> </p>

mohit_dev

<p>I am using org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet, and trying to add parameter definition to rptdesign file</p>

Sharan Deshadi

     ScalarParameterHandle sph = designFactory.newScalarParameter("srt");
     sph.setIsRequired(true);
     //sph.setAllowNull(true);
     //sph.setAllowBlank(true);
     sph.setValueType(DesignChoiceConstants.PARAM_VALUE_TYPE_STATIC);
     sph.setDataType(DesignChoiceConstants.PARAM_TYPE_STRING);
     designHandle.getParameters().add(sph);