nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Change data source from program code

R2D4

Hello all, 
 
I'm quite new to BIRT and trying some stuff. I've build a report design (from Eclipse) and attached it to an XML data source. That works like a charm. I've also integrated BIRT with a simple Java application, which also works. 
 
Now I want to make the data source variable, as I have an XML database (with identically structured XML files) from which I want to generate reports. From my source I want to change the data source stored in the rptdesign. 
 
How can I do that? 
 
Example from .rptdesign : 
<pre class='_prettyXprint _lang-auto _linenums:0'>
<data-sources>
<oda-data-source extensionID="org.eclipse.datatools.enablement.oda.xml" name="[eXist] (tryout)" id="8">
<property name="FILELIST">http://localhost:8080/exist/rest//db/tryout.xml</property>
</oda-data-source>
</data-sources>
</pre>
 
Thanks!

Find more posts tagged with

Comments

JasonW

Are you just wanting to change the xml location ie the FILELIST property? You should be able to do this with script or property binding. 
This page shows how to change jdbc values 
<a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/querymod/index.php'>BIRT Example Reports</a> 
 
In your case you want to change the FILELIST property. 
 
so in the beforeOpen script try: 
this.setExtensionProperty("FILELIST", "mynewlocation"); 
 
Jason

R2D4

<blockquote class='ipsBlockquote' data-author="JasonW">Are you just wanting to change the xml location ie the FILELIST property? You should be able to do this with script or property binding. 
This page shows how to change jdbc values 
<a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/querymod/index.php'>BIRT Example Reports</a> 
 
In your case you want to change the FILELIST property. 
 
so in the beforeOpen script try: 
this.setExtensionProperty("FILELIST", "mynewlocation"); 
 
Jason</blockquote>
 
Hi Jason, 
 
Thanks for your help! 
 
Indeed, I found that the property binding of the XML data source is what I need. 
 
I'm getting somewhere, but I'm not really there yet. I've added a parameter to the property binding. At runtime, I set this parameter with the URI of the XML file. That works fine! Also, the report renders just fine, but, without any data. 
 
When I run the report design from Eclipse, without the property binding configured, my report renders fine, including all data. However, as soon as I configure the property binding, I cannot run the report from Eclipse anymore (not even when setting the default value of the paramater for the property binding to an existing, correct, XML file). Perhaps this is standard behavior (because of the overridden data source?)?. 
 
Where should I start to look? 
 
Best, R

JasonW

Property Binding only happens when you run the report and should work in the designer as long as the designer has access to what you changed in the datasource. What error are you getting?

Jason

R2D4

<blockquote class='ipsBlockquote' data-author="JasonW">Property Binding only happens when you run the report and should work in the designer as long as the designer has access to what you changed in the datasource. What error are you getting? 
 
Jason</blockquote>
 
Hi Jasom 
 
The thing is... I didn't get any fancy error... just "error". I found out this was due to some bad report; any other report with parameters just works fine. 
 
Best, R