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; } } }

Use of Design and Report API in scripted dataset open method

Federico

I have an xml data source. I need to insert a chart line in my report and I cannot get all data from single/joint dataset as there are some complex calculation I cannot perform using simple XML. 
I need to create a scripted datasaset that reads data from the input xml and performs some calculation in order to define correct values for a chart line. 
I created the scripted datasource and scripted dataset in my report, following "Sample BIRT Scripted Data Source Example". 
 
In the open method of my scripted dataset I have 
 
testsByDateClass = new Packages.com.customer.birt.ModifyRunningReport(); 
testsByDateArray = testsByDateClass.getChartLineData(); 
totalrows = testsByDateArray.size(); 
currentrow = 0; 
 
When running the report, the factory variables is not creates but solves to null: 
 
IReportEngineFactory factory = (IReportEngineFactory) Platform.createFactoryObject( IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY ); 
 
Questions: 
 
- May I use report engine and data engine APIs on open method of scripted dataset ? 
- May I open the same report (test_report.rptdesign) in the open method ? 
- Why the factory is not get created ? 
 
Following is the method that fails: 
 
public Vector getChartLineData () 
{ 
 
IReportEngine engine=null; 
EngineConfig config = null; 
DataEngine de = null; 
Vector<Date> vTestsDates = null; 
Vector<Test> vTests = null; 
Vector<TestChartLineRow> vTestRows = null; 
try{ 
 
// Configuration Tasks 
config = new EngineConfig( ); 
config.setBIRTHome("C:\\birt-runtime-2_6_2\\ReportEngine"); 
config.setLogConfig(null, Level.FINE); 
 
// Platform startup 
Platform.startup( config ); 
IReportEngineFactory factory = (IReportEngineFactory) Platform.createFactoryObject( IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY ); 
// This is where I get NPE 
engine = factory.createReportEngine( config ); 
de = DataEngine.newDataEngine( engine.getConfig(), null ); 
//Open the report design 
IReportRunnable design = engine.openReportDesign("reports/test_report.rptdesign"); 
 
 
ReportDesignHandle reportDesHandle = (ReportDesignHandle) design.getDesignHandle( ); 
ElementFactory elementFactory = reportDesHandle.getElementFactory( ); 
 
// Need to get dataset values during design phase 
// Get datasource and execute query 
SlotHandle dataSources = reportDesHandle.getDataSources(); 
Iterator it = dataSources.iterator(); 
DesignElementHandle dataSource = null; 
if( it.hasNext() ) 
{ 
dataSource = (DesignElementHandle) it.next(); 
} 
// Retrieve datasets defined on report 
SlotHandle datasets = reportDesHandle.getDataSets(); 
it = datasets.iterator(); 
while( it.hasNext()) 
{ 
DesignElementHandle designEl =(DesignElementHandle)it.next(); 
 
if( designEl.getName().equals( "AllTests")) 
{ 
OdaDataSourceDesign odaDataSource = new OdaDataSourceDesign( "Scripted All Tests Source" ); 
odaDataSource.setExtensionID( "org.eclipse.datatools.enablement.oda.xml" ); 
odaDataSource.addPublicProperty( "FILELIST", dataSource.getProperty("FILELIST").toString() ); 
 
OdaDataSetDesign odaDataSet = new OdaDataSetDesign( "Scripted All Tests Dataset" ); 
odaDataSet.setDataSource( odaDataSource.getName( ) ); 
odaDataSet.setExtensionID( "org.eclipse.datatools.enablement.oda.xml.dataSet" ); 
odaDataSet.setQueryText( designEl.getProperty("queryText").toString() ); 
 
de.defineDataSource(odaDataSource); 
de.defineDataSet(odaDataSet); 
 
QueryDefinition queryDefinition = new QueryDefinition( ); 
queryDefinition.setDataSetName( odaDataSet.getName() ); 
queryDefinition.setAutoBinding(true); 
 
// Actually execute query 
IPreparedQuery pq = de.prepare( queryDefinition ); 
IQueryResults qr = pq.execute( null ); 
 
 
vTestsDates = new Vector<Date> (); 
vTests = new Vector<Test> (); 
vTestRows = new Vector<TestChartLineRow> (); 
IResultIterator resIt = qr.getResultIterator(); 
int rowCount = 0; 
while ( resIt.next( ) ) 
{ 
Date scheduledFinish = resIt.getDate("ScheduledFinishDate"); 
if( scheduledFinish != null ) 
{ 
if( !vTestsDates.contains(scheduledFinish)) 
vTestsDates.add( scheduledFinish ); 
} 
Date actualFinish = resIt.getDate("ActualFinishDate"); 
if( actualFinish != null ) 
{ 
if( !vTestsDates.contains(actualFinish)) 
vTestsDates.add( actualFinish ); 
} 
String revision = resIt.getString("revision"); 
String id = resIt.getString("ID"); 
 
Test test = new Test(id, revision, scheduledFinish, actualFinish); 
vTests.add(test); 
rowCount++; 
} 
Collections.sort(vTestsDates); 
 
for( Date testDate : vTestsDates) 
{ 
int totalCurrent = 0; 
int totalBaseline = 0; 
int totalActual = 0; 
 
for( Test test : vTests ) 
{ 
if ( test.getRevision().indexOf(".") == -1 && 
test.getScheduledFinish() != null && test.getScheduledFinish().compareTo(testDate) <= 0 ) 
{ 
totalCurrent++; 
} 
if ( test.getRevision().indexOf(".") != -1 && 
test.getScheduledFinish() != null && test.getScheduledFinish().compareTo(testDate) <= 0 ) 
{ 
totalBaseline++; 
} 
if ( test.getRevision().indexOf(".") == -1 && 
test.getActualFinish() != null && test.getActualFinish().compareTo(testDate) <= 0 ) 
{ 
totalActual++; 
} 
} 
 
vTestRows.add(new TestChartLineRow(testDate, totalCurrent, totalBaseline, totalActual)); 
} 
 
 
 
System.out.println("Number of dates " + vTestsDates.size()); 
 
System.out.println("Date --- Current --- Baseline ---- Actual"); 
for( TestChartLineRow row : vTestRows) 
{ 
System.out.println( row.getEventDate() + " --- " + row.getTotalCurrent() + " --- " + row.getTotalBaseline() + " --- " + row.getTotalActual() ); 
} 
 
Vector rows = new Vector(); 
for( TestChartLineRow row : vTestRows) 
{ 
System.out.println( row.getEventDate() + " --- " + row.getTotalCurrent() + " --- " + row.getTotalBaseline() + " --- " + row.getTotalActual() ); 
rows.add(new Object[]{row.getEventDate(), row.getTotalCurrent(),row.getTotalBaseline(), row.getTotalActual()}); 
} 
System.out.println("done"); 
return rows; 
} 
 
} 
}catch(Exception e) 
{ 
e.printStackTrace(); 
try{ 
// Create file 
FileWriter fstream = new FileWriter("c:\\temp\\out3.txt"); 
BufferedWriter out = new BufferedWriter(fstream); 
 
final Writer result = new StringWriter(); 
final PrintWriter printWriter = new PrintWriter(result); 
e.printStackTrace(printWriter); 
 
 
out.write(result.toString()); 
//Close the output stream 
out.close(); 
}catch (Exception ex){//Catch exception if any 
System.err.println("Error: " + ex.getMessage()); 
} 
 
} 
 
return new Vector(); 
}

Find more posts tagged with

Comments

There are no comments yet