Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Using the BIRT engine and dynamic select lists
Migrateduser
<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
There are no comments yet