Bug 200144 Exception occurs when nested table share the parent table's result set.[0005]
Description: Exception occurs when nested table share the parent table's result set.[0005] Build number: 2.2.1.v20070816-0630 Steps to reproduce: 1, New a table1 with one binding 2, Insert another table into table1 and share the table1's resultset 3, Preview Actual result: Exception occurs when preview Error log: org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report; nested exception is: java.lang.IllegalStateException: forward reference dataset org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.createQuery(ReportQueryBuilder.java:912) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitTableItem(ReportQueryBuilder.java:609) org.eclipse.birt.report.engine.ir.TableItemDesign.accept(TableItemDesign.java:44) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:246) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitCell(ReportQueryBuilder.java:806) org.eclipse.birt.report.engine.ir.CellDesign.accept(CellDesign.java:156) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:246) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitRow(ReportQueryBuilder.java:792) org.eclipse.birt.report.engine.ir.RowDesign.accept(RowDesign.java:100) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:246) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.handleListingBand(ReportQueryBuilder.java:705) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitTableItem(ReportQueryBuilder.java:641) org.eclipse.birt.report.engine.ir.TableItemDesign.accept(TableItemDesign.java:44) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:246) org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:228) org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:136) org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:94) org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59) org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:50) org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59) org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:138)
data/org.eclipse.birt.data.tests/test/org/eclipse/birt/data/engine/api/APITestCase.java
for ( int i = 0; i < groupDefn.length; i++ )
				queryDefn.addGroup( groupDefn[i] );
		}
		if ( sortDefn != null )
		{
			if ( bindingNameSort != null )
				for ( int i = 0; i < bindingNameSort.length; i++ )
					queryDefn.addResultSetExpression( bindingNameSort[i],
							bindingExprSort[i] );
			for ( int i = 0; i < sortDefn.length; i++ )
				queryDefn.addSort( sortDefn[i] );
		}
		if ( filterDefn != null )
		{
			if ( bindingNameFilter != null )
				for ( int i = 0; i < bindingNameFilter.length; i++ )
					queryDefn.addResultSetExpression( bindingNameFilter[i],
							bindingExprFilter[i] );
			for ( int i = 0; i < filterDefn.length; i++ )
				queryDefn.addFilter( filterDefn[i] );
		}
		
		if ( bindingNameRow != null )
			for ( int i = 0; i < bindingNameRow.length; i++ )
				queryDefn.addResultSetExpression( bindingNameRow[i],
						bindingExprRow[i] );
		return queryDefn;
	}
	
}