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
onFetch() not available for XML 'Join Data Set'
Migrateduser
Hi,<br />
<br />
I'm using Birt 2.6.2 with Javascript.<br />
<br />
The data sitution is a classical one to many relation with 3 tables.<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>SYSTEM <- SYSTEMCOMPONENT -> COMPONENTS</pre>
A system with some attributes and many components with their attributes assigned to a system.<br />
<br />
In my report I need to use code inside onFetch() of my ODA Data Set.<br />
<br />
Having an SQL DB as datasource I can put all JOINS inside my SQL query and have only one Dataset with all my data.<br />
For that one Dataset I can use code inside onFetch().<br />
<br />
Having XML as datasource, I have to map all elements in different 'Data Set' Elements <br />
and have to use 'Join Data Set' Elements to bring everything together in one (Join)Data Set Element like in SQL.<br />
But for 'Join Data Set' Elements there are no scripts like beforeOpen() or onFetch() available.<br />
In the script tab is to see 'This element has no methods'.<br />
<br />
If I need such a 'Join Data Set' Element just as a binding source for a grid, there is no problem.<br />
<br />
But if I want to script over all data I can't use just one of the single 'Data Set' Elements.<br />
I need the object that contains all elements, but that is not possible.<br />
<br />
How can I use onFetch() if the datasource is XML and I have to use 'Join Data Set' Elements ? <br />
<br />
regards<br />
germobirt
Find more posts tagged with
Comments
There are no comments yet