Question:
I need to be able to print results of a query to an Excel spreadsheet rather than to a report. I am using the Crystal Reports product included with Oracle Power Objects. However, it clearly states that the Crystal Reports OCX does not work with Windows 3.1, so I am using the Crystal Reports DLLs.
One of the functions I need to use requires the use of a composite data type. In Visual Basic this would look like:
Public Type variable-name SubVariable_Name1 as DataType SubVariable_Name2 as DataType…End TypeUnfortunately this declaration does not work for OPO. And I can find nosimilar method anywhere.
How can I declare a composite user-defined data type in Oracle Power Objects for use in these DLL functions?
Answer:
I’m pretty sure you can’t declare a composite data type in Power Objects.However, if I wanted to save the data from a query to a spreadsheet, I’duse the ODBC driver for Excel, open a spreadsheet as a data source and justdo simple INSERTs to the spreadsheet.
This should work, although I have not tried it.