Can I launch an Oracle form (.fmx) from CR 8.5?

[qu1ncy]

Hi,

I'm looking for a way for my CR users to populate an Oracle temporary reference table with an "as-of" date. I'm aware of Crystal's inability to pass variables down to the datasource, which in this case is an Oracle backend. I've checked faqs & forums to no avail, but I've come across some pretty creative work-arounds in this forum and I'm hoping someone has devised a way to do this.

The easy way is to simply ask users to open their Oracle front end, open the appropriate form, enter their "as-of" date and then open CR and run their report.

However, can I launch this Oracle form as soon as they demand the report, have them enter the date in the form (which updates the Oracle table), and then have the report produced on the close of the form?

FYI: The "as-of" date is being referenced by the view that this report is based on.

I would be grateful for any assistance with this.

Thanks

Q

 

[synapsevampire]

Crystal 9 can update an Oracle database through SQL, but I wouldn't advise approaching it this way.

Since what you intend to do is start by updating a database, open an Oracle form and do so, then call the report from the Oracle form.

-k

 

[qu1ncy]

Thanks K. I appreciate the feedback.
Q