Help coderanch get a
new server
by contributing to the fundraiser

Crystal Wong

Greenhorn
+ Follow
since Feb 27, 2008
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by 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
16 years ago
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 query1 = "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!
16 years ago