Create word document based on query in oracle reports

Advertisement

Database version
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for HPUX: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
CREATE TABLE TAB1
DEPT_ID NUMBER,
DRIVE_ID CHAR(10 BYTE),
QC_TYPE_ID CHAR(4 BYTE),
QC_SUBTYPE_ID CHAR(4 BYTE),
EQUIP_CODE VARCHAR2(20 BYTE),
CREATE_TIME DATE
Insert into TAB1
(DEPT_ID, DRIVE_ID, QC_TYPE_ID, QC_SUBTYPE_ID, EQUIP_CODE,
CREATE_TIME)
Values
(14, 'DRV5535359', '1011', '1012', 'HEMORYA070',
TO_DATE('08/07/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into TAB1
(DEPT_ID, DRIVE_ID, QC_TYPE_ID, QC_SUBTYPE_ID, EQUIP_CODE,
CREATE_TIME)
Values
(14, 'DRV5535359', '1011', '1012', 'HEMORYA089',
TO_DATE('08/07/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into TAB1
(DEPT_ID, DRIVE_ID, QC_TYPE_ID, QC_SUBTYPE_ID, EQUIP_CODE,
CREATE_TIME)
Values
(14, 'DRV5535359', '1011', '1014', 'SEALCEN007',
TO_DATE('08/07/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into TAB1
(DEPT_ID, DRIVE_ID, QC_TYPE_ID, QC_SUBTYPE_ID, EQUIP_CODE,
CREATE_TIME)
Values
(95, 'DRV2016629', '1008', '1012', 'HEMORYA124',
TO_DATE('08/07/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into TAB1
(DEPT_ID, DRIVE_ID, QC_TYPE_ID, QC_SUBTYPE_ID, EQUIP_CODE,
CREATE_TIME)
Values
(95, 'DRV2016629', '1008', '1012', 'HEMORYA125',
TO_DATE('08/07/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into TAB1
(DEPT_ID, DRIVE_ID, QC_TYPE_ID, QC_SUBTYPE_ID, EQUIP_CODE,
CREATE_TIME)
Values
(95, 'DRV2016629', '1008', '1013', 'SEALCEN032',
TO_DATE('08/07/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into TAB1
(DEPT_ID, DRIVE_ID, QC_TYPE_ID, QC_SUBTYPE_ID, EQUIP_CODE,
CREATE_TIME)
Values
(11, 'DRV5533643', '1011', '1012', 'HEMORYA099',
TO_DATE('08/07/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into TAB1
(DEPT_ID, DRIVE_ID, QC_TYPE_ID, QC_SUBTYPE_ID, EQUIP_CODE,
CREATE_TIME)
Values
(11, 'DRV5533643', '1011', '1026', 'HEMORYA100',
TO_DATE('08/07/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into TAB1
(DEPT_ID, DRIVE_ID, QC_TYPE_ID, QC_SUBTYPE_ID, EQUIP_CODE,
CREATE_TIME)
Values
(11, 'DRV5533643', '1011', '1026', 'SEALCEN008',
TO_DATE('08/07/2012 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
COMMIT;
Sample table and data
Wanted help if any experts out there to help me create word output instead of pdf or excel format report
select * from tab1;
DEPT_ID|DRIVE_ID|QC_TYPE_ID|QC_SUBTYPE_ID|EQUIP_CODE|CREATE_TIME
14|DRV5535359|1011|1012|HEMORYA070|8/7/2012
14|DRV5535359|1011|1012|HEMORYA089|8/7/2012
14|DRV5535359|1011|1014|SEALCEN007|8/7/2012
95|DRV2016629|1008|1012|HEMORYA124|8/7/2012
95|DRV2016629|1008|1012|HEMORYA125|8/7/2012
95|DRV2016629|1008|1013|SEALCEN032|8/7/2012
11|DRV5533643|1011|1012|HEMORYA099|8/7/2012
11|DRV5533643|1011|1026|HEMORYA100|8/7/2012
11|DRV5533643|1011|1026|SEALCEN008|8/7/2012
Edited by: user_anumoses on Aug 23, 2012 1:20 PM

Advertisement

Well, I know you've been asked before, but it seems you're either incapable or just plain lazy when it comes to helping us to help you. You haven't bothered to format your code using the appropriate tags, and you haven't provided all the information needed, and it looks like you haven't even bothered to post it in the correct forum (there's a forum specifically for Oracle Reports).
I'll ask you once more to read this: {message:id=9360002}
As best I know (and I haven't worked on Oracle reports for many years), it is only capable of producing PDF 'out of the box', so any other reporting format would need to be developed by yourself. You haven't even specified whether you're using client based reports or web based (application server) reports, and solutions could vary depending on that.
Don't expect much help if you can't be bothered to follow simple guidelines in asking questions.

November 30, -0001

Create word document based on query in oracle reports

Database version Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production PL/SQL Release 9.2.0.8.0 - Production CORE 9.2.0.8.0 Production TNS for HPUX: Version 9.2.0.8.0 - Production NLSRTL Version 9.2.0.8.0 - Production CREATE TABLE TAB1 DEP

How to create pdf files in UNIX directory from oracle reports

I would like to know how to create pdf files in UNIX directory from oracle reports. Thanks,Please make your question more clear . Also mention the reports version. 1) If you are runnning reports in Unix, you can give .... destype=file desformat=pdf d

Can't create Word Document report - need help

Hi, I have been trying to create a report using a word document. I downloaded an example from ni.com that has Export_Info.vi. When I try to run it I get this error: Error 1003 occurred at Open VI Reference in New Report.vi->Export_Info.vi I traced th

Hot to display PDF and Word documents as an attachment in OBIEE Reports

Hi, From few of Oracle threads I learnt that we can store the files in a server locaiton and read it thro a URL. What I am trying to do is, PDF or Word document will be stored in database as BLOB fields. This BLOB field needs to be come as an attachm

Running Web Layout Of JDBC Query in Oracle Report Builder 11g.

javax.servlet.jsp.JspException: REP-4100: An attempt to execute data source failed. JDBCPDS-62008:A SQL error occurred: {0}. S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt javax.servlet.jsp.JspException: RE

New documents:  Configure SSL and Integrate Oracle Reports

All, Be sure to check out these new documents from Oracle Support on the Oracle9iAS Portal Center. Support page: http://portalstudio.oracle.com/servlet/page?_pageid=1787&_dad=ops&_schema=OPSTUDIO 1. Configure Oracle9iAS Portal to use SSL with Glob

Create word document from PDF

Export PDF gives me PNG doc NOT word doc.Hi Don Grundeen, Make sure you are choosing the right Export format. Regards, FlorenceRead other 2 answers

Infopath Multi Textbox and OpenXML to generate word document

 Hi, I'm reading multiple InfoPath Textbox (set to display multiple lines) using OpenXML and generating a word document based on a template collecting data from InfoPath. I'm using following code,  the code gives error in AddMultiLineText at Paragrap

Using JSP/Servlet to write Word Document to BLOB

Hi I need some help pls When I use a normal class with a main method, it loads the word document into a blob and I can read this 100%.Stunning. With a JSP/Servlet I cannot get the document out again. The "format" seems to be lost. Any ideas,help

Unable to Create Work Document in SharePoint 2010 by one user

Hi,    We have a unique issue. One user in our organisation is not able to create Word Document in our SharePoint environments. We have SharePoint 2010 Enterprise Edition and Office 2010 Professional Edition. This issue is faced by only one user in o

Opening Word document with OLE

Hello, I must have a case of own-code-blindness, could anyone see what the problem is? A blank document is created but I can't get it to load the file... <snip> app := CLIENT_OLE2.CREATE_OBJ('Word.Application'); CLIENT_OLE2.SET_PROPERTY(app, 'Visibl

Open & attach word document on clients machine

I want to open & attach word document on client machine from Oracle Forms, all my trials failed. I am using Oracle 10G I want detailed steps to do so. Best Regards Message was edited by: user630033Hi, ... I would ask this question in the Forms-Forum

Search a Word Document for a particular word

Hi, I want to search a Word Document based on a particular word, using Java technology.... Could any one of U suggest me a way out as to how to proceed, if possible with code.... Thanks and Regards, Rajesh.POI can read & write Word docs.Read other 2

HOW TO OPEN WORD DOCUMENT FROM JAVA???

hi everyone! Can you please help me to come with this problem? Let me to set my main target I want to achieve: 1) In my program user should first press a button; 2) Then already created Word Document should be opened (I DO NOT NEED to open that Word

Word document templates and Protection

We have implemented a Portal Solution for Sales Representatives, we allow them to create word documents by using a template, Once the template is filled by the data in the application we call the Execute Macro Method so that the Macro used to protect

How do I edit word document attachments

HI, i have a new iPad for work. I have installed both the free word app and the Polaris office app. I am able to receive word attachments and view them, but it won't allow me to open them for editing in the apps. I hold on the attachment, but the opt

How to create a BAPI based on R/3 report?

Hi, I have a requirement to create a BAPI based on an R/3 report. the selection screen elements shold be the parameters that we pass to the BAPI and output of the report will be the output for the BAPI. I have issue creating the bapi structure for se

Exception while opening a JSP file created using oracle report builder

I have created a JSP page which contains embedded Oracle reports build using Oracle Report Builder. I have deployed the JSP created above to the Oracle Application Server but when i try to open the JSP file it gives the following error: 500 Internal

Lexical Parameter in Oracle Reports . . .

Hi all, I am trying to pass a value to a query in oracle reports . . . the use of the parameter is to add 2 additional columns to an existing query, if a bind parameter is set to 'Yes' else the parameter carries a value NULL; Here is the code I have

How create a fillable web based form from MS Word document

I have imported my MS Word document into Acrobat 9 Designer.  Now what?  I am totally lost, is there a guide out there some where that could be of some benefit.  Has anyone done this before?  Can not get it to preview or test so how do I know what I