Home
Analytics
Using the BIRT engine and dynamic select lists
idonaldson
<p>Hello,</p><p> </p><p>We seem to be missing a crucial step in running my reports that use dynamic select lists. We have a Grails application that is using the BIRT plugin, which works all fine and dandy, except for the fact all my select lists are empty and show up as text boxes because of that.</p><p> </p><p>Here is how we have this setup:</p><p> </p><p>rptlibrary -> dataSource -> dataset -> parameter</p><p> </p><p>I add this parameter, we'll call it term, to my report.</p><p> </p><p>If I run the report in the Web Viewer in Eclipse, I get a list back with 37 term values. Awesome, everything is working as expected. Now, I run our other application that runs the report, and there are no values returned when this method runs</p><pre class="_prettyXprint">IGetParameterDefinitionTask task...task.getSelectionList(param.name)</pre><p>I get back an empty list.</p><p> </p><p>My gut is telling me there is a step missing somewhere that runs the SQL contained in the dataset, but I can't seem to find it online or in the "Integrating and Extending BIRT 3rd edition" manual.</p><p> </p><p>Here's what the parameter xml looks like in the rptdesign file. If having the entire report would help, let me know.</p><pre class="_prettyXprint _lang-xml"><parameters> <scalar-parameter name="Term" id="229" extends="brp.Term"> <text-property name="promptText">Please select a Term Code</text-property> <property name="valueType">dynamic</property> <expression name="valueExpr" type="javascript">dataSetRow["STVTERM_CODE"]</expression> <expression name="labelExpr" type="javascript">dataSetRow["STVTERM_CODE"]</expression> <property name="dataType">string</property> <property name="distinct">true</property> <list-property name="selectionList"/> <property name="paramType">simple</property> <property name="controlType">list-box</property> <property name="mustMatch">false</property> <property name="fixedOrder">true</property> <structure name="format"> <property name="category">Unformatted</property> </structure> </scalar-parameter> </parameters></pre><p>Thanks and any help is greatly appreciated,</p><p> </p><p>Ian</p><p> </p>
Find more posts tagged with
Comments
idonaldson
<p>Nevermind, Everything is working once I restarted my computer. I'm blaming Eclipse.</p>