From TEST to PROD

[byteias]

CR XI under Oracle 9i.
I created a master-detail (using subreports) report and when I run it through TEST works without problem. Then when I connect it to PROD (using the SET DATASOURCE LOCATION updating it from TEST to PROD) I get about 50 times the amount of rows (repeats the set of 203 rows).
I notice when I show the SQL QUERY, it gives me an extra query which is not shown in TEST.
Any ideas about it?
Thanks,
Ivan.

 

[byteias]

this is the SQL that shows in TEST:
SELECT DISTINCT "XCR_PERF_JOB_MTHLY_V"."MAT1"
, "XCR_PERF_JOB_MTHLY_V"."MATERIAL_CUR_100"
, "XCR_PERF_JOB_MTHLY_V"."MATERIAL_TD FROM "SASCO"."XCR_PERF_JOB_MTHLY_V" "XCR_PERF_JOB_MTHLY_V"
WHERE "XCR_PERF_JOB_MTHLY_V"."MONTHYEAR"='200705' AND "XCR_PERF_JOB_MTHLY_V"."PROJECT_NUMBER"=22123
Retrieves 1 Row only.

these are the SQL that shows in PROD:
SELECT DISTINCT "XCR_PERF_JOB_MTHLY_V"."MAT1"
, "XCR_PERF_JOB_MTHLY_V"."MATERIAL_CUR_100"
, "XCR_PERF_JOB_MTHLY_V"."MATERIAL_TD FROM "SASCO"."XCR_PERF_JOB_MTHLY_V" "XCR_PERF_JOB_MTHLY_V" WHERE "XCR_PERF_JOB_MTHLY_V"."MONTHYEAR"='200705' AND "XCR_PERF_JOB_MTHLY_V"."PROJECT_NUMBER"=22123

SELECT DISTINCT "XCR_PERF_JOB_MTHLY_V"."PROJECT_NUMBER" FROM "SASCO"."XCR_PERF_JOB_MTHLY_V" "XCR_PERF_JOB_MTHLY_V" ORDER BY "XCR_PERF_JOB_MTHLY_V"."PROJECT_NUMBER"
Retrieves 592 Row only.

 

[synapsevampire]

Very odd indeed, but you neglect to state what you have in the Database->Database Expert for data sources. That is where Crystal determines what should be used.

Are you using tables, dynamic parameters, comandobjects, how many are listed there?

Also make sure that you're using the same connectivity, and post that information as well.

If you're using the Oracle supplied ODBC driver,than it makes sense that you have problems,it isn't compatible with Crystal.

-k

 

[byteias]

I get another error after changing the datasource and try to save it, gives the error "Failed to save document".
Using views (master) and table (deetail)
dynamic parameters (2)
using the same connectivity: OLE DB (ADO) Provider: MSDAORA

 

[synapsevampire]

Switch to Oracle Server listed under more Data Sources. It's a native connection, and faster.

Not sure why you opted for the slower, error prone OLEDB.

-k

 

[byteias]

I don't see Oracle server under more Data Source....How do I get it?

 

[byteias]

I keep trying to run my report from PROD and now I get "Invalid Argumnet Provided".
When I press PF5 it will ask me if I want to use current parameter value or Prompt for a new selection.
I select Prompt and I make a new selection (?MonthYear and ?project) then I press okay and I get the following messages: "Failed to retrieve data from the database" and "Invalid Argumnet Provided".
I created a quick report (with parameters)using the same view in PROD and runs okay.
Thanks.

 

[BlurredVision]

I'm having the same issue.. Did you ever find a work around for this?