Search results for query: *

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...

I using Crystal Reports 9 Developer on Win2K. And, yes, I do have a printer installed. This is where I printed the report; initially directly from CR and later from MS-Word via an exported document.

I have a report that's designed to print in portrait orientation, which it does if I print the report directly from Crystal. However, if I export the report to Word For Windows format and then open the document in MS-Word it comes up as landscape. Arghhhh!!!!! Anyone know how to stop this...

No, it is trying to print locally. Actually, I figured out the problem. I forgot that by default, the Oracle services are run by user "LocalSystem" which of course doesn't have any printers installed. As soon as I restarted the Oracle services with my user ID the FilePrint method starting...

You were absolutely correct. Problem solved. This is in fact how I have the production databases setup for very similar reasons, but silly me forgot about this when creating the database on my computer. Thanks for your help!!!!!

Sorry, it seems like I didn't make it clear that everything is local to my desktop. The Oracle9 database is running on my Win2k desktop and the PL/SQL procedures create an MS-Word document in a folder on my C: drive, so there's no server involved. Since the FileOpenNew, Insert and FileSave...

I've written a number of PL/SQL procedures that successfully use the ORDCOM package to create a Word.Basic object, open a new MS-Word document, insert text into the document and then save it. Where I'm having a problem is when I go to print the document. It seems like I should just be able to...

I've written a number of PL/SQL procedures that successfully use the ORDCOM package to create a Word.Basic object, open a new MS-Word document, insert text into the document and then save it. Where I'm having a problem is when I go to print the document. It seems like I should just be able to...

I'm using Oracle's COM Automation feature to manipulate MS-Word documents from PL/SQL procedures. I can create a Word.Basic object, open a new document, write to it and save it without a problem. However, when I use the "FilePrint" method to print the doc on my default printer, I get the error...