Dataset afterOpen() Row Count

Eclipse Indigo 3.7.1.r37x_v20110810-0800-7b7qFVtFEx2XnmZ4jlM5mjM 
Build id: M20110909-1335 
 
BIRT 3.7.1.v20110905-4607w31221A16 
BIRT Build id: v20110913-1734 
 
BIRT JDBC Data Source 
File: jtds-1.2.5.jar 
Driver Class: net.sourceforge.jtds.jdbc.Driver (v1.2) 
 
 
Is there a way (using scripting example: dataset afterOpen()): 
1. Determine dataset row count 
2. If row count exceeds a predetermined value: 
 
Pop-up message: Please Reduce The Selection Criteria 
Abort report or allow user to select new criteria 

 
Please note setting the data set row limit is not desirable. 
 
Thank you for the great support you have provided in the past. 
BIRT rocks!

Find more posts tagged with

Comments

mwilliams

One option could be that you could create a connection to your database in your beforeFactory script and check the return of your query with the selected parameters. If they exceed your limit, you could drop all the elements from your report except for a text box that tells them their selections returned too many values and to select new criteria. Then you could provide a button to "try again" that would re-run the report.

joeguzman1

Can you please provide an example. 
I tried using the following function in beforeFactory() but got a connection error. 
 
beforeFactory() 
GetRowCount("Report_dsJob_History_by_Date"); 
 
function GetRowCount(DataSet) 
{ 
importPackage(Packages.org.eclipse.birt.report.model.api ); 
importPackage(Packages.java.lang); 
importPackage(Packages.java.util); 
importPackage(Packages.org.eclipse.birt.data.engine.api); 
importPackage(Packages.org.eclipse.birt.report.model.api); 
importPackage(Packages.org.eclipse.birt.data.engine.api.querydefn); 
importPackage(Packages.org.eclipse.birt.data.engine.core); 
 
var myconfig = reportContext.getReportRunnable().getReportEngine().getConfig(); 
var de = DataEngine.newDataEngine( myconfig, null ); 
 
var dsrc = reportContext.getDesignHandle().findDataSource("opconxps"); 
var dset = reportContext.getDesignHandle().findDataSet(DataSet); 
 
var odaDataSource = new OdaDataSourceDesign( "Test Data Source" ); 
odaDataSource.setExtensionID( "org.eclipse.birt.report.data.oda.jdbc" ); 
odaDataSource.addPublicProperty( "odaURL", dsrc.getProperty("odaURL").toString() ); 
odaDataSource.addPublicProperty( "odaDriverClass", dsrc.getProperty("odaDriverClass").toString()); 
odaDataSource.addPublicProperty( "odaUser", dsrc.getProperty("odaUser").toString() ); 
odaDataSource.addPublicProperty( "odaPassword", "" ); 
 
var odaDataSet = new OdaDataSetDesign( "Test Data Set" ); 
odaDataSet.setDataSource( odaDataSource.getName( ) ); 
odaDataSet.setExtensionID( "org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" ); 
odaDataSet.setQueryText( dset.getQueryText() ); 
 
de.defineDataSource( odaDataSource ); 
de.defineDataSet( odaDataSet ); 
 
queryDefinition = new QueryDefinition( ); 
queryDefinition.setDataSetName( odaDataSet.getName() ); 
queryDefinition.setAutoBinding(true); 
 
 
var pq = de.prepare( queryDefinition ); 
 
var qr = pq.execute( null ); 
 
rowcount=0; 
var ri = qr.getResultIterator( ); 
while ( ri.next( ) ) 
{ 
rowcount++ 
} 
 
ri.close( ); 
qr.close( ); 
de.shutdown( ); 
 
return rowcount; 
}

mwilliams

Take a look at this devShare post. Maybe it'll help.

http://www.birt-exchange.org/org/devshare/designing-birt-reports/1428-birt-jdbc-oda-with-jdbc-resultset-override/

adagreen

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="95712" data-time="1328897646">
<div>
Take a look at this devShare post. Maybe it'll help. <a data-ipb='nomediaparse' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/1428-birt-jdbc-oda-with-jdbc-resultset-override/'>http://www.birt-exchange.org/org/devshare/designing-birt-reports/1428-birt-jdbc-oda-with-jdbc-resultset-override/</a>
</div>
</blockquote>
Thanks a ton!!
Very helpful. :P

mehdiesteghamat

hi,
 
I am trying to do that using initialize, and onFetch method as below but not working. Please let me know what is wrong.
 
thank you in advance,
 
 
-- initialize
reportContext.setPersistentGlobalVariable("myrowcount","0");
 
-- onFetch
<div>a = parseInt(reportContext.getPersistentGlobalVariable("myrowcount"))+1;</div>
<div>a++;</div>
<div>reportContext.setPersistentGlobalVariable("myrowcount",a.toString());</div>
 
 
-- onRender
this.text="Rowcount = " + reportContext.getPersistentGlobalVariable("myrowcount");