I'm having a problem generating reports in Crystal for Java when the report being used has subreports.
If I have a simple report with no subreports I do the following, then redirect to a JSP, and the report works correctly:
ResultSet resultSet = getResultSet();
dbController.setDataSource(resultSet, tableAlias, "resultsettable");
However, if the report I'm using contains subreports, I get the error "Error finding JNDI name (stage)" from the crystal viewer. The servlet that creates the report gets an exception that start with the following:
09/13/2007 16:49:37 ERROR com.businessobjects.reports.sdk.JRCCommunicationAdapter - JRCAgent1 detected an exception: Error finding JNDI nam
e (stage)
at com.crystaldecisions.reports.reportdefinition.datainterface.a.a(Unknown Source)
What do I need to do in this case to get the report to work correctly? Do I need to reset connectionInfo for all subreports? If so, which properties to I need to add to the propertyBag for an Oracle database.