Calling Report from Oracle Stored procedure 2

[mmemon]

Hello

We have a Coldfusion app that we found out can't integrate with Crystal Reports based on the versions we have. So, we thought we would make a call to an oracle stored procedure which in turn would make a call to a crystal report. Can this be done? What would the code look like? And can we NOT have the report displayed i the browser to the user. We would want oracle to call the report and export it to pdf.

Thanks
Michele

 

[Turkbear]

Hi,
AFAIK, you cannot ( without lots of coding in C, and maybe not then) call a crystal report from within an Oracle SP..

What you could do is have the SP create the data you need and report against that ( if it returns a REF CURSOR - or have it populate an existing table with new rows with a unique ID , like a sequence #)...an asp page could call the SP and then run the report.



BTW, what Oracle version?

 

[mmemon]

Hi,

Oracle 9i. We are now thinking of Coldfusion calling the rptserver.asp page to process our report. I don't expereince with this but I have been searching the web all morning.

Michele

 

[Oracle9Guy]

Yes you can run a Crystal report from an Oracle stored procedure. You need to install Oracle's COM Automation package (ORDCOM) and use it to write your own procedures to interface with the Crystal RDC. Take a look at the following document. It has examples of doing similar things with MS-Word and MS-Excel (for example, creating a Word document from PL/SQL).

http://ipto.hin.no/oradoc/win.920/a95499/title.htm

Let me know if you think this is the way you want to go and I'll send you a PL/SQL package I've developed for working with Crystal. It has procedures for:

- Creating a Crystal Application object.
- Opening a Crystal Report (ie, an .RPT file saved without data)
- Logging in to a database.
- Setting parameter values.
- Printing the report.
- Exporting the report.
- Destroying the Crystal Application object.

 

[anushakrish]

hi

i am using php and oracle8i. can i do the same in this version oracle if so pls pass me code

 

[cjmartin]

Oracle9Guy,

Can you send that PL/SQL package to me? That may help us with our challenges...

Thanks!

 

[synapsevampire]

Oracleguy: Looks interesting, please forward the PL/SQL package along to me:

crystalreports at hotmail

btw, the link you posted doesn't seem to work today.

Thanks,

-k

 

[Neki]

Can you send that PL/SQL package to me?
I'm trying to call Crystal Reports 10 from Oracle Application.
Thanks

Neki