Select Problem CR 10

[thendrickson]

I am having a difficult time with selecting recors for a report

The data source is an Oracle proc which accepts input parameters and returns the proper data

The report has 2 additional parameters (numeric ranges) that I need to use to limit the records further

When I place those parameters in the Crystal Record selection formula, I receive no records. However, when I run the report wih only the parameters required by the proc, I receive the records I need

The proc is quite complex and would be require dynamic sql to accept the 2 numeric range parmeters so I would like to avoid that if possible

Simple explanation:
Pass Parameters A, B, C to proc.
Returns records
CRystal record selection then selects (From the proc cursor) where column_A in (Parameter 1) AND column_B in (parameter 2)

Enviroment
Oracle 10.2.0.10
Crystal 10

I do have a fallback plan if this cannot be done, but it will be difficult to convince the users to go along with.

 

[Turkbear]

Hi,
Can you post the SQL that Crystal creates after you have supplied those 2 parameters?

It is possible that they are being passed to Oracle and affecting the record selection of the Proc.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[thendrickson]

They were not being passed, but thanks for the idea. I checked that

I went with plan B and pass all parameters to the proc. The users actually like that idea better.

The report is perfect in Preview mode, but fails to run when published to Crystal Enterprise with the following

Status: Failed
Printer: The instance is not printed.
External Destination: None
Creation Time: 8/5/2010 9:46:18 AM
Start Time: 8/5/2010 9:46:18 AM
End Time: 8/5/2010 9:46:19 AM
Server Used: binary.reportjobserver
Error Message: Query Engine Error. File C:\Program Files\Crystal Decisions\Enterprise 10\Data\procSched\binary.reportjobserver\~tmp105063dec471580.rpt.

I will post this problem in the proper forum