JRC - multiple tables in crystal report

[Crystal Wong]

Hi,

I am using the Java Reporting component of Crystal Report XI R2 SP2.

I encounter error when pushing 2 Java resultset to a report as a
datasource, like the code belows,

ReportClientDocument reportClientDoc = new ReportClientDocument();
reportClientDoc.open(REPORT_NAME, 0);

String query1 = "SELECT COLUMN1, COLUMN2 FROM TABLE1" ;
ResultSet resultSet1 = getResultSetFromQuery(query1,
ResultSet.TYPE_SCROLL_INSENSITIVE);
String tableAlias1 =
reportClientDoc.getDatabaseController().getDatabase().getTables().getTable(0).getAlias();
reportClientDoc.getDatabaseController().setDataSource(resultSet1,
tableAlias1 , tableAlias1);

String query2 = "SELECT COLUMN1, COLUMN2 FROM TABLE2" ;
ResultSet resultSet2 = getResultSetFromQuery(query2,
ResultSet.TYPE_SCROLL_INSENSITIVE);
String tableAlias2 =
reportClientDoc.getDatabaseController().getDatabase().getTables().getTable(1).getAlias();
reportClientDoc.getDatabaseController().setDataSource(resultSet2,
tableAlias2 , tableAlias2);

I wanna to ask, Does JRC support multiple tables in a report with the
approach suggested above?

Thanks a lot!

 

[Crystal Wong]

Finally, I decided to use a join SQL or SubReport to do it.

Re-write SQL to form a single ResultSet and push it in into the
report, OR
To push one ResultSet to each SubReport => multiple tables in a report