 MATRIX REPORT TO EXCEL FILE [message #261353] |
Wed, 22 August 2007 06:39  |
vidya.soujanya
Messages: 4
Registered: August 2007
Location: chennai |
Junior Member |
|
|
hi,
can any one help me out how to generate matrx report to excel file. i have done this . but the exact layout is not getting diplayed in the excel file.
I have attache the layout i ma trying to export to excel.
I am attaching the out put file also
Please help me out.....
Attachment: layout.doc
(Size: 106.00KB, Downloaded 116 time(s))
[Updated on: Wed, 22 August 2007 06:40]
|
|
|
| Re: MATRIX REPORT TO EXCEL FILE [message #261368 is a reply to message #261353 ] |
Wed, 22 August 2007 07:11  |
musman
Messages: 141
Registered: July 2007 |
Senior Member |
|
|
here is an example ...i think it will be help full..
RPT2XLS procedure is used ...
|
|
|
| Re: MATRIX REPORT TO EXCEL FILE [message #261369 is a reply to message #261353 ] |
Wed, 22 August 2007 07:13 |
musman
Messages: 141
Registered: July 2007 |
Senior Member |
|
|
plus read this and i think u can easily export ur matrix report to EXCEL..
Attachment: readme.txt
(Size: 3.26KB, Downloaded 184 time(s))
|
|
|
| Re: MATRIX REPORT TO EXCEL FILE [message #261374 is a reply to message #261369 ] |
Wed, 22 August 2007 07:21 |
vidya.soujanya
Messages: 4
Registered: August 2007
Location: chennai |
Junior Member |
|
|
hi,
i am uploading my rdf file to this. pleas check the export to excel coding i have specified in afterparameter form.
please help me out.......
|
|
|
| Re: MATRIX REPORT TO EXCEL FILE [message #318654 is a reply to message #261374 ] |
Wed, 07 May 2008 08:27 |
Fomich
Messages: 1
Registered: May 2008
Location: Russia, Moscow |
Junior Member |
|
|
Hi, all.
I try to launch MATRIX_DEMO.rdf with inserted RPT2XLS.Run into AfterReport Trigger.
The parameters is
2008-05-07 17:04:59: startrep.exe "RWRUN.exe" userid="FOMICHEV/***@TEST10G" REPORT="c:\MATRIX_DEMO.rdf" PRINTJOB=NO DESTYPE=file DESNAME="1.xls" MODE=Bitmap COPIES=1 DESFORMAT=PDF BACKGROUND=No PARAMFORM=NO P_TITLE="Report"
as written in readme.txt.
But i receive bad XLS file as shown in picture below.
When i change DESFORMAT to DELIMITED, then i receive error message
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: BACKGROUND is deprecated. See help for more information.
REP-1401: 'afterreport': Fatal PL/SQL error occurred.
ORA-43356: Message 43356 not found; product=RDBMS; facility=ORA
305500: non-ORACLE exception
I have Oracle Reports 10g ( 9.0.4), Windows 2000 SP 2, MS Office Excel 2003 Service Pack 3 and Oracle 10.2.0.3.0.
Can you help me ?
Attachment: 1.gif
(Size: 24.99KB, Downloaded 3 time(s))
|
|
|
]
Members
Search
Help
Register
Login
Home
