Welcome and thank you for joining our new OpenText forum. Your questions, responses, best practices, and tips shared with other members will help make this channel vibrant. We're glad you're joining us and look forward to collaborating with you online.

Check out the Getting Started With OpenText Forums for tips on personalizing your experience.

How to set parameters in Report created through DEAPI

Hi,


 


I want to use parameterised query, where I should be able to set values through URL or JavaScript.


I am using the same example code at http://www.eclipse.org/birt/resources/documentation/integrating/DeDemo.java.


 


Also is there a way add drop down to this report which can set the parameters for the report.


 


Thanks,


Mohit


 


Comments

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


  • 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.