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
Problem with report after BIRT upgrade to 4.4 from 4.2
Migrateduser
<pre class="_prettyXprint _lang-xml">
<cell id="194">
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<grid id="365">
<property name="pageBreakAfter">auto</property>
<property name="pageBreakBefore">auto</property>
<property name="pageBreakInside">auto</property>
<property name="dataSet">Currencies</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">EXCH_CURRENCIES_ID_PK</property>
<expression name="expression" type="javascript">dataSetRow["EXCH_CURRENCIES_ID_PK"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">EXCH_CUR_ID</property>
<expression name="expression" type="javascript">dataSetRow["EXCH_CUR_ID"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">CUR_CURRENCY</property>
<expression name="expression" type="javascript">dataSetRow["CUR_CURRENCY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CUR_DISPLAY</property>
<expression name="expression" type="javascript">dataSetRow["CUR_DISPLAY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CUR_CREATED</property>
<expression name="expression" type="javascript">dataSetRow["CUR_CREATED"]</expression>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">CUR_UPDATED</property>
<expression name="expression" type="javascript">dataSetRow["CUR_UPDATED"]</expression>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">CUR_UPDATED_BY</property>
<expression name="expression" type="javascript">dataSetRow["CUR_UPDATED_BY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">Aggregation</property>
<property name="dataType">string</property>
<property name="aggregateFunction">CONCATENATE</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value" type="javascript">row["CUR_CURRENCY"]</expression>
</structure>
<structure>
<property name="name">Separator</property>
<expression name="value" type="javascript">","</expression>
</structure>
<structure>
<property name="name">Max length</property>
</structure>
<structure>
<property name="name">Show all values</property>
</structure>
</list-property>
<expression name="filterExpr" type="javascript">row["EXCH_CUR_ID"]==row._outer["EXCHANGES_ID_PK"] && row["CUR_DISPLAY"]=="Y"</expression>
</structure>
</list-property>
<column id="366"/>
<row id="367">
<property name="pageBreakInside">auto</property>
<cell id="368">
<data id="770">
<property name="resultSetColumn">Aggregation</property>
</data>
</cell>
</row>
</grid>
</cell>
</pre>
<p>Good Morning,</p>
<p> </p>
<p>We have had a set of BIRT reports which have been stable for a few years, but we have recently been pushed internally within our organisation to a new version of BIRT and one of our reports has stopped working.</p>
<p> </p>
<p>I am not, and have never developed BIRT reports before so please excuse any ignorance while I learn what is required to make this report start working.</p>
<p> </p>
<p>We have a cell within the report:</p>
<p> </p>
<p>After some trial and error it would appear the problem is the reference to the row._outer</p>
<p> </p>
<p>What this nested table is doing is saying filter this child table where this child record belongs to the parent.</p>
<p> </p>
<p>This has always worked previously, is there anyway I can easily refer to the parent here to allow this filtering to take place?</p>
<p> </p>
<p>Many Thanks</p>
<p> </p>
<p>Chris</p>
Find more posts tagged with
Comments
There are no comments yet