Selective Reporting

EdK01

What if any are the facilities to:
1) dynamically connect a dataset with one of several tables.
2)drop a row in the details section for certain values of the data? (not just make it invisible, drop it so that no blank space appears where it would have been).

Thanks
Ed K

Virgil Dodson

Hi Ed,<br />
<br />
You can dynamicaly construct an entire BIRT report if you like. This can be done in a Java class with the Design Engine APIs... or through scripting inside a report design. Take a look at the example at <a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/117-dynamic-content-creation-in-birt/#description'>Dynamic Content Creation in BIRT - Designs & Code - BIRT Exchange</a><br />
<br />
as for dropping a row vs hiding it. The code below in the beforeGeneration method will find a table named CustomerTable... and drop the second detail row (0 based) if the user checked the parameter.<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
if (params["deleteOrders"] == true){
//don't forget to name table

mytable = reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("CustomerTable");

mytable.getDetail().get(1).drop();
}
</pre>