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

Joint Data Set not displaying data

Chris in Alabama

Hi,

New to BIRT, drinking from a fire hose, and (I think) in the deep end of the pool.

I have two scripted data sets where the tables are populated using EventHandler classes. The problem begins when I create a joint data set using the two scripted data sets. The joint data set displays no data. I am displaying the scripted data sets on the report with no problem.

What have I missed?

Thanks,

Chris

Find more posts tagged with

Comments

mwilliams

Is it just not showing in the preview of the dataSet editor? Or is it not showing if you drag the dataSet into your design and run it? What is your BIRT version?

Chris in Alabama

First, thanks for the help. Second, apologies for the long post but when I tried the CODE style it looked horrible. 
 
I am using version 3.7.2. 
 
Due to the architecture in place I am getting Java ArrayList as parameter values. 
 
I have built several reports requiring separate data sources but this is my first attempt at a joint data source. 
 
During a preview the datasets are empty so, as I would expect, no data at all shows up but I do get all the header information for the datasets. 
BTW, how does one populate the data set during development for priviews when there is no database/webservice available? 
 
I am running the report as an integration test using JUnit 4. 
 
When I run the integration test the output file has the data for the two scripted data sets but only the header info for the joint data set. 
 
I am using eventhandlers only on the tables for the scripted data sets( ThingOne and ThingTwo ). 
 
I am building my test data as follows: 
 
(imports and package info scrubbed) 
public class ThingOneDevelopmentDataGenerator { 
private static final String [][] data = 
{ 
{ "01A", "RA1-01A", "RA1" } , 
{ "125", "RA1-125", "RA1" } , 
{ "200", "RA1-200", "RA1" } 
}; 
 
public static List<GroupDetail> getData(){ 
List <GroupDetail> l = new ArrayList<GroupDetail>(); 
 
for ( int i = 0; i < data.length; i++ ){ 
GroupDetail rec = new GroupDetail(); 
rec.setGroupCode(data[0]); 
rec.setGroupName(data[1]); 
rec.setLabCode(data[2]); 
l.add(rec); 
} 
 
return l; 
} 
} 
 
public class ThingTwoDevelopmentDataGenerator { 
private static final String [][] data = { 
{ "01A", "BA848DB376BE4B7AE04400212861D336" }, 
{ "01A", "BA848DB375E54B7AE04400212861D336" }, 
{ "01A", "BA848DB375E34B7AE04400212861D336" }, 
{ "125", "BA848DB37CFF4B7AE04400212861D336" }, 
{ "125", "BA848DB37BFB4B7AE04400212861D336" }, 
{ "125", "BA848DB373234B7AE04400212861D336" }, 
{ "125", "BA848DB3719A4B7AE04400212861D336" }, 
{ "125", "BA848DB36ADD4B7AE04400212861D336" }, 
{ "200", "BA848DB37EC64B7AE04400212861D336" }, 
{ "200", "BA848DB36E934B7AE04400212861D336" }, 
{ "200", "BA848DB36B584B7AE04400212861D336" }, 
{ "HAA", "BA848DB36D2D4B7AE04400212861D336" }, 
{ "HAA", "BA848DB36D2C4B7AE04400212861D336" }, 
{ "HAA", "BA848DB36CDA4B7AE04400212861D336" }, 
{ "HAA", "BA848DB36A614B7AE04400212861D336" } 
}; 
public static List <GroupOwnerAssociation> getData(){ 
List <GroupOwnerAssociation> l = new ArrayList(); 
for ( int i = 0; i < data.length; i++ ){ 
GroupOwnerAssociation rec = new GroupOwnerAssociation(); 
rec.setEquipmentOwnerId(data[1]); 
rec.setGroupCode(data[0]); 
l.add(rec); 
} 
return l; 
} 
} 
 
The test is: 
 
@Test 
public void testRunnerUsingDefaultPDFRenderOption() throws Exception { 
 
GroupReportRunner runner = new GroupReportRunner(); 
 
ReportsDao dao = new GroupReportDaoImpl(); 
dao.setRenderOption(dao.PDF_RENDER_OPTION); 
 
List l = GroupDetailDevelopmentDataGenerator.getData(); 
System.out.println( l.size() ); 
dao.setParameterValue(GroupReportDaoImpl.GROUP_KEY, 
GroupDetailDevelopmentDataGenerator.getData()); 
 
dao.setParameterValue(GroupReportDaoImpl.GROUP_EQUIPMENT_OWNER_ASSOCIATIONS, 
GroupOwnerXrefDevelopmentDataGenerator.getData()); 
 
OutputStream os = new BufferedOutputStream(new FileOutputStream( 
new File("e:/temp/headerInfo.pdf"))); 
dao.setOutputStream(os); 
 
runner.executeReport(dao); 
 
} 
 
 
 
/* 
The main infrastructure for running the report engine is contained in AbstractReportRunner. 
*/ 
public class GroupReportRunner extends AbstractReportRunner { 
private static final Logger logger = Logger 
.getLogger(GroupReportRunner.class); 
private static final String REPORT_DESIGN = "header_info.rptdesign"; 
 
public void executeReport(ReportsDao dao) throws EngineException { 
executeReport( dao, REPORT_DESIGN ); 
} 
}

mwilliams

Is the report that's not showing the joint dataSet data just a table with the joint dataSet data in it? If so, can you try putting two text boxes in front of that table, in your report and binding one of them to your first dataSet and one to the second? Can you attach your report? Better yet, if you could recreate this in a way that I can run the report, that'd be helpful.

Chris in Alabama

I made some discoveries in the past few hours.

While grasping at straws I decided to delete all tables from the layout, drag the joined dataset to the layout, and run the report. There was data in the table using the joined data set.

I then dragged the scripted data sets to the layout editor and ran the report. The joined dataset still had data but the tables using the scripted data sets did not.

I then reversed the order of the tables and the tables using the scripted data sources showed data and the joined table did not. (The original condition)

The only thing that changed was the order of the tables in the layout.

It appears that once a data source's records are processed the records are no longer available. This behavior is different from my use of datasets populated via jdbc not using eventhandlers.

What should I read to better understand what is going on in the internals?

How do I make the rows available for processing in subsequent event handlers?

I have attached the two output files and the datahandler class.

Once again, thanks for the help.