Changed the schema and got a Record Selection folmula error

[handle1134]

Hi

I created in a paralel schema the same table for my report, having the same columns.
When I run this report I get a "Failed" status with a reason:

Error in formula <Record Selection>. '...'
This field name is not known. Details: errorKind

I have 20 fields in my formula, and it doesnt say witch one is not known.
After that I have made another report from the designer, identical with the first one (including the same Record Selection formula). This one works.
The problem is that I have to use the same report for several schemas, not building one every time I change the schema.
Besides the database logon information (ReportLogons: username, password) what else should I change to make a report work with another schema?

10x

 

[IdoMillet]

Use
Database, Verify Database...

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[handle1134]

I use Crystal reports XI 2, and a JDBC conector to a Oracle 10g database.
Here is the JDBC tag of my CRConfig.xml :

<JDBC>
<CacheRowSetSize>100</CacheRowSetSize>
<JDBCURL>jdbcracle:thin192.168.1.42:1521:gemini</JDBCURL>
<JDBCClassName>oracle.jdbc.driver.OracleDriver</JDBCClassName>
<JDBCUserName>PIQ_R2</JDBCUserName>
<JNDIURL></JNDIURL>
<JNDIConnectionFactory></JNDIConnectionFactory>
<JNDIInitContext>/</JNDIInitContext>
<JNDIUserName>weblogic</JNDIUserName>
<GenericJDBCDriver>
<Option>No</Option>
<DatabaseStructure>catalogs,tables</DatabaseStructure>
<StoredProcType>Standard</StoredProcType>
<LogonStyle>Oracle</LogonStyle>
</GenericJDBCDriver>
</JDBC>

I need to change the datasource location, to use on several database schemas, but not changing the report from the Crystal Reports designer. Can it be done?