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

 

[SantaMufasa]

1134,

Can you generate this error from within a SQL*Plus session? If so, it would help us to help you if you could please copy and paste to here the screen contents of your SQL*Plus session, including the offending code and the error message, along with an example of the "working code" that you said does not generate an error condition.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[handle1134]

(I dont use SQL+, forgot to mention, sorry.)

I use Crystal Reports XI 2 for report design, and a JDBC connector to a Oracle 10g database.
Using the Bussines Objects API, I try to schedule some reports, but it looks like the database schema is hardcoded in the .rpt file.
The only way I can acces data from another schema is to modify the report from the designer (Crystal Reports). The database logon info, the schedule info and report parameters could be modified from the Java code, but I cant get to the database schema. Every report only works on its designed schema.
Can I change it from somewhere else but the designer ?

This is what I use to change some of the report info:

CrystalReport rpt = CrystalReportsRepository.getInstance().getReport(reportId);
BIPlatform biPlatform = SessionUtils.getInstance().getBIPlatform();

SchedulingInfo schedulingInfo = rpt.getSchedulingInfo();
ReportProcessingInfo reportProcessingInfo = rpt.getPluginProcessingInterface();

// sets server, user&psw
setDBLogonInfo(reportProcessingInfo);

InfoObjects objects = new InfoObjects();
InfoObject[] rptObject = new InfoObject[1];
rptObject[0] = rpt;
objects.setInfoObject(rptObject);
biPlatform.update(objects);