Java and Crystal Reports XI: Dynamic Changing of Data Source

[Gary Villavicencio]

Good day,
this is my first post here, should i violate any rules, please accept my humblest apologies.

I would like to ask your help regarding my problem. I'm using Eclipse Europa and Crystal Reports XI. What I would like to do is to dynamically change the Data Source of my Crystal Report. I believe I have done that with these codes:

// Obtain collection of tables from this database controller.
Tables tables = rptClientDoc.getDatabaseController().getDatabase().getTables();

// Set the datasource for all main report tables.
for (int i = 0; i < tables.size(); i++) {

	IProcedure table = (IProcedure)tables.getTable(i);
	//ITable table = tables.getTable(i);

	//Change Name - since we are switching stored proc name as well
	table.setName(spName);
	table.setAlias(spName);
	table.setParameters(params);	
	
	//Change properties that are different from the original datasource.
	table.setQualifiedName(DB_NAME + "." + spName);
						
	//Change connection information properties.
	IConnectionInfo connectionInfo = table.getConnectionInfo();
			
	PropertyBag innerProp = connectionInfo.getAttributes();
	innerProp.clear();
				
	//Set new table connection property attributes.
	PropertyBag propertyBag = new PropertyBag();
			
	//Overwrite any existing properties with updated values.
	propertyBag.put("Trusted_Connection", "b(false)");
	propertyBag.put("Server Name", SERVER_NAME);
	propertyBag.put("Connection String", CONNECTION_STRING);
	propertyBag.put("Server Type", "JDBC (JNDI)");
	propertyBag.put("Database Class Name", DB_CLASS);
	propertyBag.put("Use JDBC", "true");
	propertyBag.put("URI", URI);
	propertyBag.put("Database DLL", DB_DLL);
					
	connectionInfo.setAttributes(propertyBag);
			
	//Set database username and password.
	//NOTE: Even if these the username and password properties don't change when switching databases, the 
	//database password is *not* saved in the report and must be set at runtime if the database is secured.  
	connectionInfo.setUserName(USER_NAME);
	connectionInfo.setPassword(USER_PWD);
	connectionInfo.setKind(ConnectionInfoKind.SQL);
			
	table.setConnectionInfo(connectionInfo);
			
	//Update old table in the report with the new table.
	rptClientDoc.getDatabaseController().setTableLocation(table, tables.getTable(i));
			
}

But I recieve this Error Message: JRCAgent1 detected an exception: Unknown EROM field value type
...
Unknown EROM field value type---- Error code:-2147213290 Error code name:tableNotExist

Your help will be very much appreciated.

Thanks