How to set parameters in Report created through DEAPI

mohit_dev
mohit_dev
edited February 11, 2022 in Analytics #1
<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>

Comments

  • mohit_dev
    mohit_dev
    #2
    <p>I am using org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet, and trying to add parameter definition to rptdesign file</p>
  • Sharan Deshadi
    Sharan Deshadi
    edited March 19, 2018 #3 
         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);

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs