Home Analytics Developing analytics applications
The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

How to set parameters in Report created through DEAPI

<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

  • <p>I am using org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet, and trying to add parameter definition to rptdesign file</p>
  • edited March 19, 2018
         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); 
    
Sign In or Register to comment.